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

I need to pull data based on anything >Date()-2 3:00pm Ideas?

P: 1
I need to pull data based on anything >Date()-2 3:00pm How would I do this to input into a query?
May 29 '15 #1
Share this Question
Share on Google+
3 Replies


jforbes
Expert 100+
P: 1,107
I'm not exactly sure what you are trying to do, but you might want to look into the DateDiff() function.
May 29 '15 #2

Rabbit
Expert Mod 10K+
P: 12,430
You mean 2 days before today at 3pm? Use the DateAdd function to sutract 2 days. Truncate the time portion. Use DateAdd to add 15 hours.
May 29 '15 #3

NeoPa
Expert Mod 15k+
P: 31,769
Rather than modifying your data I would suggest finding the value that you're after and compare your data with that. Generally that value will only need to be calculated once for the whole query.
Expand|Select|Wrap|Line Numbers
  1. DateAdd('h',15,DateAdd('d',-2,Date()))
May 31 '15 #4

Post your reply

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