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

Query for Current Date plus one hour of previous date

P: 1
I have a field that displays the date of the transaction. I'm trying to build a query that will display that date plus the last hour of the previous date.

i.e., display all times for 1/14/15 plus the last hour of 1/13/15.
Jan 15 '15 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,484
balfourr,

You may have to play with the DateAdd() function. I assume you mean that you will want all transactions from 1/14/15 plus all transactions from 11:00 PM on 1/13/15?

You would have to have a combination of using DateAdd() with Days and Hours.
Jan 21 '15 #2

Post your reply

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