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
-~----------~----~----~----~------~----~------~--~---

Reply via email to