Figuring out the Picasa.ini date format

  • Thread starter martix
  • Start date
  • #1
147
0

Main Question or Discussion Point

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?
 

Answers and Replies

  • #2
-Job-
Science Advisor
1,146
1
It would be a good idea to post an example of the date format you're referring to.
 
  • #3
147
0
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:
  • #4
-Job-
Science Advisor
1,146
1
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.
 
  • #5
1,250
2
From the example you posted it looks to me like it is measuring the number of days starting at some reference date.
 
  • #6
1
0
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
 
Last edited by a moderator:

Related Threads for: Figuring out the Picasa.ini date format

  • Last Post
Replies
10
Views
197
Replies
2
Views
2K
Replies
6
Views
13K
  • Last Post
2
Replies
36
Views
4K
  • Last Post
Replies
4
Views
3K
  • Last Post
Replies
2
Views
2K
Top