It does, but look at it this way if you did it in CF It works on the current date and time so the following is what will happen
20/02/2002 04:12:34 When you do a -24 with the hh option, the new date would be 19/02/2002 04:12:34 So as you can see when you do a between it will only find anything between the dates and the times that is why you have to do that extra bit of code... I have falling into that trap a few times before I clicked, and unless you do it often it will still get you at times. -----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 February 2002 12:52 PM To: SQL Subject: RE: BETWEEN and date functions Thanks Andrew, That fixed the problem. I was trying to be clever and let the database do all the work - bad move. I assumed that DateAdd would create a time too, seeing as 'hh' is a valid parameter! And it's tricky because I can't see any way to output the value that DATEADD is creating. Kay. ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
