A huge thanks to all who took the time to respond. Now I am a little wiser
and it is working.
Tony Gruen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_list
ah yeah, you got the picture ;-) The key is that you need to include the
timestamp info.
-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]
Sent: 01 July 2003 17:07
To: CF-Talk
Subject: RE: Little OT: SQL Query Date Filter
-- Original Message
-- Original Message --
From: "Robertson-Ravo, Neil (RX)" ermhow about :
>
>WHERE bDate >= #variables.EDate# 00:00:00
>AND bDate <= #variables.TDate# 23:59:59
Since that would get 3 days' worth (that would get you transactions on EDate and
TDate, wouldn
Sounds like you are using SQL Server.
This is expected behavior because 6/30/2003 01:01:01.01 is greater than
6/3/2003 00:00:00.03 (think that's right). The second one is what you are
creating.
I believe that what you really want is :
Select *
from transactions
where bDate >= #variables.EDate#
SELECT *
FROM Transactions
WHERE bDate between #variables.EDate# AND #variables.TDate#
where the dates can be any two dates, the query will return allthings
matching, including things *on* those dates.
using < less than and > greater than, excludes stuff not there...does
this make sense...
so if
ermhow about :
WHERE bDate >= #variables.EDate# 00:00:00
AND bDate <= #variables.TDate# 23:59:59
SQL Server uses the timestamp alongside the date as well.
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]
Sent: 01 July 2003 16:56
To: CF-Talk
Subject: Little OT: SQL Q
6 matches
Mail list logo