>From first view the number represents the number of days since a specified date in time. Looks like the number of days since AD 0 (guessing??). The difference between the two is 3968 which works out to be about a little over 10 yrs difference which seems about right.
hth Rod On Apr 3, 5:17 pm, "Tom MacKean" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---