Of course,
693,594 I should have know, that how many fish Jesus created when he fed the masses :) Regards Dale Fraser http://dale.fraser.id.au/blog _____ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom MacKean Sent: Thursday, 5 April 2007 12:27 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Date format For anyone still interested in this thread, I thought I might show my final conclusions... The database is called Bluechip (a product of HCN, the folks who brought you Medical Director) and anyone working in the health industry may come across it. To get a date from a Bluechip date integer subtract the constant 693594 from the integer and hand over to CF. e.g. #dateformat(DOB-693594,"d/m/yyyy")# Strangely, if DOB is null, the result is 2/1/0001 Thanks to everyone for their help and suggestions. Tom On 4/5/07, paulineb <[EMAIL PROTECTED]> wrote: Tom, If you use the following, which is an extract from a component I wrote to convert Active Directory account expiry filetime to utc time, you get quite different results. AD stores dates as nanoseconds since 1/1/1601, but I'd say that these dates are probably seconds since 1/1/1970 or seconds from 30/12/1899, so I've cut out the part that deals with nanoseconds! . cfscript code snippet: interimDate1 = DateAdd("s", 716640, "30/12/1899 00:00:00"); interimDate2 = DateAdd("s", 712672, "30/12/1899 00:00:00"); interimDate3 = DateAdd("s", 716640, "01/01/1970 00:00:00"); interimDate4 = DateAdd("s", 712672, "01/01/1970 00:00:00"); // Convert UTC to local. convertedDate1 = createodbcdatetime(DateConvert("utc2local", interimDate1)); convertedDate2 = createodbcdatetime(DateConvert("utc2local", interimDate2)); convertedDate3 = createodbcdatetime(DateConvert("utc2local", interimDate3)); convertedDate4 = createodbcdatetime(DateConvert("utc2local", interimDate4)); If you output these dates you get you get the same actual days, but different times. {ts '1900-01-07 17:04:00'} {ts '1900-01-07 15:57:52'} {ts '1970-01-09 17:04:00'} {ts '1970-01-09 15:57:52'} Which date range do you think tour dobs are from? You should be able to work out which one of these to use. Doesn't quite make sense to me that both Excel and CF are showing the date years 3862 and 3851. They have to be working in seconds maybe, not days since a certain date. Hope this helps. Pauline -- 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 -~----------~----~----~----~------~----~------~--~---