Viewing 3 posts - 1 through 3 (of 3 total)
WOW!
Thank you so very much!
April 2, 2005 at 2:34 pm
#550247
The only thing I can see is if the two datetime items are less than 24 hrs apart but not on the same day you might have a problem. ...
April 2, 2005 at 1:46 pm
#550244
I always use BETWEEN and then have a 24 hour day.
For Example
Where (myDate BETWEEN '4/1/2005 00:00:00' AND '4/1/2005 23:59:59')
April 2, 2005 at 11:42 am
#550237