Tom,
The number is simple it is a date that is number of seconds from a given
date, if you type the number into excel it is going to do its best to
convert that number to a date.
The actual problem as I tried to find the code that I came up with fro
coldfusion, is simple to achieve.
The solution would be to do <cfset date = DateAdd('s',value,"01/01/1980") />
And that will give you the correct date from the time specified in Julian
dates converted to CF, excel doesn't do this for you it just tries to
convert number to a date object.
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Tom MacKean
Sent: Wednesday, 4 April 2007 11:18 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Date format
Actually Excel returns the same result when you force it to use a four digit
year.
Tom
On 4/4/07, Chris Velevitch <[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 095
www.flashdev.org.au
<br
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
