Barry
I think we all do. I did the same thing a few years ago to, and even posted a solution to this from a mssql database. Tom: Yeah it is a Julian format, and is commonly used in storing dates in mySql servers. 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 Barry Beattie Sent: Wednesday, 4 April 2007 10:42 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Date format no waste at all, IMHO. I stumbled across this with dateformat() by pure accident three years ago and then completely forgot. had you not reminded me with your problem I probably would have forgotten this for good. thanx for the mental jog (there's always a silver lining to look for) b On 4/4/07, Tom MacKean < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: OK. Feeling a bit silly now. #dateformat(718167,"d.m.yy")# works a treat. It gives 9.4.66 which is the same result as Excel (and I assume is correct) 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 key is that the year is only two digits. Sorry for wasting everyone's time :( T On 4/4/07, Tom MacKean <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: The funny thing is, Excel recognises these numbers as dates. If I paste one of the numbers into Excel, then do Format Cell > Date and choose the last option on the list, Excel will happily turn it into a correct date. To my thinking, it must therefore be a fairly standard way of formatting a date and yet I can find nothing about it anywhere. Very weird. More Googling needed I think. Thanks for all your help. T On 4/3/07, rod higgins <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Trying to create a date of 0001/01/01 is alot of fun in CF - I cant seem to create one using createdate(). I imagine Tom you will have to use something like the code below to generate a reference date to compare the integers against. <cfset mydate = createdate(1962,2,2)> <cfset refdate = dateadd("d", -716640, mydate)> <cfoutput> #dateformat(refdate, 'yyyy/mm/dd')# </cfoutput> hth Rod -- 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. -- 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 -~----------~----~----~----~------~----~------~--~---