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