Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Figuring out the Picasa.ini date format

  1. May 16, 2008 #1
    I have this image organization program called Picasa. It uses hidden .ini files in each directory it monitors to set some settings. I am interested in the date setting.
    I need to figure out what the Picasa.ini date format is, so I can create a ton of such files with a little 5-minute-to-code program, instead of doing it by hand for an hour.
    Can anyone help out?
     
  2. jcsd
  3. May 17, 2008 #2

    -Job-

    User Avatar
    Science Advisor

    It would be a good idea to post an example of the date format you're referring to.
     
  4. May 17, 2008 #3
    Well I doubt it would become clear from a few examples, but it generally looks like date=43243.546435 - 5 digits then a dot and six more.
    Say 30/6/2001 is date=37072.672245
    and 20/8/2001 is date=37128.691157
     
    Last edited: May 17, 2008
  5. May 18, 2008 #4

    -Job-

    User Avatar
    Science Advisor

    The example values you posted, are they the actual values corresponding to the dates you provided, or something you randomly created for the sake of an example?

    The encoding doesn't look standard, at least i haven't come across it before. It may be the number of miliseconds since some date, such as January 1970, or some function of that value.
     
  6. May 18, 2008 #5
    From the example you posted it looks to me like it is measuring the number of days starting at some reference date.
     
  7. Jul 27, 2008 #6
    The picasa.ini date format appears to be the same as used in the openoffice spreadsheet and probably excel. The digits to the left of the decimal point are the number of days since 12/30/1899 and the digits to the right represent the time.
    Here is a link to more information about the format and some code to convert dates between numbers and the mm/dd/yy forms.

    The link: http://www.codeproject.com/KB/datetime/exceldmy.aspx?print=true
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?