dmyoungsal
Registered User.
- Local time
- Today, 07:03
- Joined
- May 1, 2016
- Messages
- 112
I have a query from which I want to pull only those records that have been updated in the last hour.
In my file, I have a DateTime field (12/21/2016 9:18 AM). I would like the query to include this record and others if the time and date have changed within the last hour.
I have read that using DateAdd would do the trick, but I am having problem getting the format correct. Is that even the correct thing to use?
I also have two fields that I use to split DateTime onto the separate fields (Date and Time).
Suggestions?
In my file, I have a DateTime field (12/21/2016 9:18 AM). I would like the query to include this record and others if the time and date have changed within the last hour.
I have read that using DateAdd would do the trick, but I am having problem getting the format correct. Is that even the correct thing to use?
I also have two fields that I use to split DateTime onto the separate fields (Date and Time).
Suggestions?