I think the actual problem might lie in your Mortgage = 'yes' statement.
Try the code below.
<CFSET CurrentDate = CreateDate(ToYear, ToMonth, ToDay)>
SELECT EntryDate
FROM ChamberOrderInfo
WHERE Mortgage = 1 (is mortgage is a bit field? use this, if it is text
field with 'Yes' or 'No' (not usually the case) then do what you have
below.)
AND EntryDate = #CreateODBCDate(CurrentDate)#
BYron
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 10:01 AM
To: [EMAIL PROTECTED]
Subject: Searching Access Date Field
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.
------------------------------------------------------------------------------
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.