Before Y2K I changed all the databases to long date, now I am having problems
searching a date field. This is how I create the date
<CFSET TO = "#CreateODBCDate(CREATEDATE(TOYEAR,TOMONTH, TODAY))#">
THis is how I search it
Select ENTRYDATE
from ChamberOrderInfo
WHERE MORTGAGE = 'YES'
AND ENTRYDATE = #TO#
So if the date comes up with March 3, 2000 it shows no records, but there are records
there. Am I formatting the date wrong. Can anyone help. It's driving me crazy.
Bob Everland
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
