Hi all,
This is probably an easy one. But i wanted to know what would be the easiest way to setup a query on a date field that will capture all date values that are greater than today, datevalue(now()). But also greater than 05:00am
Hi all,
This is probably an easy one. But i wanted to know what would be the easiest way to setup a query on a date field that will capture all date values that are greater than today, datevalue(now()). But also greater than 05:00am
It would likely be Date() + 5/24
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
That appears to work in VBA. But when i enter that in a query field, it automatically converts to, ">=Date()+#5/24/2022#"
Add the hours using a dateadd ?
>DateAdd("h", 5, Date())
https://docs.microsoft.com/en-us/off...teadd-function
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Perfect, thanks!
Sorry, I only tested in the immediate window.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba