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

Reply via email to