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