469,917 Members | 1,989 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

dates: Comparing just the date parts of datetimes

Is there a simple way to subtract the time from a datetime field, so when I compare dates, I'm always comparing the dates at 12:00 am?

I'd really prefer not to convert all my dates to strings.


Jan 20 '09 #1
2 1789
2,878 Expert 2GB
Here are some options.

-- CK
Jan 20 '09 #2
You can use 'DateDiff' function which the parameter you want.
Jan 21 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Donnal Walter | last post: by
22 posts views Thread by mike | last post: by
2 posts views Thread by matthias s. | last post: by
2 posts views Thread by Duppypog | last post: by
6 posts views Thread by Simon Harvey | last post: by
12 posts views Thread by colincolehour | last post: by
3 posts views Thread by Keith Hughitt | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.