Figuring out the Picasa.ini date format

[martix]

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?

 

[-Job-]

It would be a good idea to post an example of the date format you're referring to.

 

[martix]

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

 

[-Job-]

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.

 

[Crosson]

From the example you posted it looks to me like it is measuring the number of days starting at some reference date.

 

[NEKGuy]

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 http://www.codeproject.com/KB/datetime/exceldmy.aspx?print=true" 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