472,138 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,138 software developers and data experts.

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 1897
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.