RE: cf question :)

[Ian Skinner]

What is wrong with January 26th 222?

I'm curious; I don't have access to SQL server to test, if the database would 
be fine with "01/26/222"?  If that's the case, then it is just being stricter 
about a leading zero.  I'm not sure that is a cause of right vs. wrong, just 
different.  But there is a chance that the database is complaining about the 
date being before 1751ish.  

Thanks to the vagaries of our Greco/Roman/Julius/Gregorian calendar funky 
things happen to dates the father back you go.  To avoid this, the system may 
just not all dates that are too old to be true date types, just strings.


--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning



...-----Original Message-----
...From: Tony Weeg [mailto:[EMAIL PROTECTED]
...Sent: Wednesday, January 26, 2005 10:45 AM
...To: CF-Community
...Subject: Re: cf question :)
...
...try using that date in SQL Server.
...
...i know cf likes it, but that doesnt mean its a valid date.
...
...tw
...
...
...On Wed, 26 Jan 2005 13:36:05 -0500, Jerry Johnson
...<[EMAIL PROTECTED]> wrote:
...> <cfoutput>#isdate("01/26/0222")#</cfoutput><br>
...>
...> YES
...>
...> Jerry Johnson
...> Web Developer
...> Dolan Media Company
...>
...> >>> [EMAIL PROTECTED] 01/26/05 01:38PM >>>
...> again, i ask...
...>
...> is
...>
...> 01/26/0222
...>
...> a valid date?
...>
...> tw
...>
...> On Wed, 26 Jan 2005 13:34:49 -0500, Michael T. Tangorre
...> <[EMAIL PROTECTED]> wrote:
...> > American Style:  MM/DD/YYYY
...> > European Style: DD/MM/YYYY
...> > ISO Locale Neutral Format: YYYY-MM-DD
...> >
...> > :-)
...> >
...> > Michael T. Tangorre
...> >
...> > > -----Original Message-----
...> > > From: Tony Weeg [mailto:[EMAIL PROTECTED]
...> > > Sent: Wednesday, January 26, 2005 1:25 PM
...> > > To: CF-Community
...> > > Subject: cf question :)
...> > >
...> > > 01/26/0222
...> > >
...> > > is that a valid date.
...> > >
...> > > --
...> > > tony
...> > >
...> > > Tony Weeg
...> > >
...> > > macromedia certified coldfusion mx developer
...> > > email: tonyweeg [at] gmail [dot] com
...> > > blog: http://www.revolutionwebdesign.com/blog/
...> > > cool tool: http://www.antiwrap.com
...> > >
...> > >
...> >
...> >
...>
...>
...
...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:5:144669
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54