My point exactly excel parses the date from 1/1/1900, so should CF. The date stored in excel is the same as CF, for Tom's example it would be stored internally as 9/4/3866 regardless of how you display it. Half way down the article; "In most modern programming environments, dates are stored as real numbers. The integer part of the number is the number of days since some agreed-upon date in the past, called the epoch. In Excel, today's date, June 16, 2006, is stored as 38884, counting days where January 1st, 1900 is 1."
So why does CF regard the integer 1 as 31/12/1899? Do others experience this or is it just a dodgy version of CF running on my localhost? -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, 4 April 2007 12:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Date format suggest you refer back to Karen's previous entry and then follow up the joelonsoftware link, about halfway donn the joelonsoftware post. it might help On 4/4/07, rod higgins <[EMAIL PROTECTED]> wrote: I can't see a bug at all. The dateformat function simply diplays the last two digits of the year of the date as it should. It the date is stored as 9.4.3866 you would expect a display of 9.4.66 wouldn't you? What I want to know is why #dateformat(1,"d.m.yyyy")# is 31/12/1899 and not 1/1/900 ?? On Apr 4, 11:07 am, "Chris Velevitch" <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: > On 4/4/07, Tom MacKean <[EMAIL PROTECTED]> wrote: > > > My confusion initially was that #dateformat(718167,"d.m.yyyy")# gives > > 9.4.3866 which didn't look right at all so I thought is wasn't working. The > > Looks like a bug in the dateformat function. Perhaps you could raise > an issue with Adobe about it. > > Chris > -- > Chris Velevitch > Manager - Sydney Flash Platform Developers Group > m: 0415 469 095www.flashdev.org.au --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---