Use between
cfquery name=qDateRange datasource=ds
SELECT * FROM dbo.PaP WHERE test_date BETWEEN #CreateODBCDate (startDate)#
AND #CreateODBCdate (endDate)#
ORDER BY #sort# ASC
/cfquery
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19,
if you are using SQL Server, make sure you are using times as well : ie.
DATE 00:00:00
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: 19 March 2003 15:17
To: CF-Talk
Subject: Q_Range of dates
I think I've got a handle on queries for output forms where they
cfset startDate=CreateDate(Form.startYear, Form.startMonth, 1)
cfset endDate=DateAdd (Form.endYear, Form.endMonth,1)
cfquery name=qDateRange datasource=ds
SELECT * FROM dbo.PaP WHERE test_date = #CreateODBCDate (startDate)#
AND test_date #CreateODBCdate (endDate)# ORDER BY #sort# ASC
In SQL, look at the BETWEEN operator:
SELECT * FROM dbo.PaP
WHERE test_date BETWEEN #CreateODBCDate(startDate)# AND
#CreateODBCdate(endDate)#
ORDER BY #sort# ASC
Adam.
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 9:17 AM
4 matches
Mail list logo