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