Ok,
It will be a julian date of some format, which is normally a number or
seconds or minutes past a certain point in time, based on the small number,
minutes.
The standard Java Time is seconds or milliseconds past 1 Jan 1970.
I tried this with yours but it didn't work, you need to know the base, so
play with this.
<cfset me = createDate(1970, 1, 1) />
<cfset me = dateAdd("s", 71664, me) />
<cfoutput>#me#</cfoutput>
And you can probably work out the base, assuming you are confident Excel
converted it correctly.
If you still have access to the old system try adding a record and see what
the number comes out as, then try to adjust such that the number gets closer
to 0, which will be the base.
Regards
Dale Fraser
http://dale.fraser.id.au/blog
_____
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Tom MacKean
Sent: Tuesday, 3 April 2007 5:18 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Date format
Hi all,
I am using ColdFusion to drag some data kicking and screaming out of a very
strange MS-based database. The date of birth field has values such as 716640
and 712672.
After a bit of mucking about I discovered that I can place this value in an
excel cell and change the format to date to give a value that seems to makes
sense. (The two values above yield 02.02.62 and 24.3.51 respectively).
Does anyone know what is going on here - and more importantly what can I do
in CF to 716640 to make it a date that I can use as a normal date.
Cheers,
Tom
--
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
