dawsonrhodes
Member
- Local time
- Today, 12:46
- Joined
- Mar 8, 2020
- Messages
- 85
Hey All!
I have a query that I am trying to run that'll populate a chart showing transactions from one period to another within the "day".
Essentially, in our business we have a time period which transactions "reset" a threshold. At 4AM every day I need to clear the query and begin only showing results from, for example, 4AM May 25, 2021 to 3:59AM May 26, 2021.
Could a between criteria be used to basically say that Date() between 4AM and 11:59 and Date() +1 between 12AM and 3:59PM?
The name of the field/control in this case is [RoFDateCompleted]
Any ideas?
Cheers!
I have a query that I am trying to run that'll populate a chart showing transactions from one period to another within the "day".
Essentially, in our business we have a time period which transactions "reset" a threshold. At 4AM every day I need to clear the query and begin only showing results from, for example, 4AM May 25, 2021 to 3:59AM May 26, 2021.
Could a between criteria be used to basically say that Date() between 4AM and 11:59 and Date() +1 between 12AM and 3:59PM?
The name of the field/control in this case is [RoFDateCompleted]
Any ideas?
Cheers!
Last edited: