bruceblack
Registered User.
- Local time
- Today, 01:58
- Joined
- Jun 30, 2017
- Messages
- 119
Hi guys! I was wondering if its possible to have the following query criteria:
I have a datefield and a timefield. I would to include
- Todays date
- Also the date minus 1 day
- Where the minus 1 day only between 00:00 and 03:00 Am
This has to do that we work till 3 am every day and the query needs to include that.
I tried this but its not working
I have a datefield and a timefield. I would to include
- Todays date
- Also the date minus 1 day
- Where the minus 1 day only between 00:00 and 03:00 Am
This has to do that we work till 3 am every day and the query needs to include that.
I tried this but its not working
Code:
=Date() AND DateAdd ("dd", -1, Date() Where [starttime] > TimeValue("00:00:00") And Time < TimeValue("03:00:00")