RE: Q_Range of dates

2003-03-19 Thread Janine Jakim
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,

RE: Q_Range of dates

2003-03-19 Thread Robertson-Ravo, Neil (RX)
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

Re: Q_Range of dates

2003-03-19 Thread Stephen Moretti
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

RE: Q_Range of dates

2003-03-19 Thread Cantrell, Adam
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