By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,379 Members | 449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,379 IT Pros & Developers. It's quick & easy.

dates: Comparing just the date parts of datetimes

P: 47
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
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
Here are some options.

-- CK
Jan 20 '09 #2

P: 12
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.