SQL Server won't accept a date before 1753.
See http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9723
JoAnn A. Schlosser
Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428
-----Original Message-----
From: Hirschman, Miriam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:18 PM
To: CF-Talk
Subject: RE: DateFormat
My main problem is that first CF considers it a date by entering the if
statement, but then it can't format it because it says it is not a date/time
value. I don't really care if the user enters a date before 1600, but is it
or isn't it a date??
Thanks
-----Original Message-----
From: Schlosser, JoAnn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:05 PM
To: CF-Talk
Subject: RE: DateFormat
If this is one of those things where it won't work for a date prior to
whenever, you can try to add 500 years up front, then subtract it at the
end.
JoAnn A. Schlosser
Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428
-----Original Message-----
From: Hirschman, Miriam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 1:51 PM
To: CF-Talk
Subject: DateFormat
Hi,
I am doing an if statement
if isdate is true
then output the field in DateFormat.....
Now the is date returns Yes==it is a date, but when the user enters a date
that is before tha year 1600-the isDate is true, but I get an error that the
field must be a Date/Time field.
Any ideas??
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
