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