I have been testing this and cannot envision a solution. SQL Server 2000 and
CF5.
I have a small table that records transactions. The date for each
transaction is recorded in createodbcdatetime format. Transactions can occur
throughout the day.
I am creating a page that shows the days transactions. The user enters a
date in mm/dd/yyyy format to query the db.
Trouble in that witht he query below when I enter 07/01/2003 I get
transactions from 06/30/2003 as well.
<CFSET CDate = "#createodbcdate(form.RptDate)#"> (this is what the user
enters as the desired date for the report)
<CFSET EDate = DateAdd('d', -1, CDate)> (yesterday's date)
<CFSET TDate = DateAdd('d', 1, CDate)> (tomorrows date)
SELECT *
FROM Transactions
WHERE bDate > #variables.EDate#
AND bDate < #variables.TDate#
Thank you in advance for your brainpower - is my method off somehow?
Tony Gruen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
