Specifying time range for extraction

3 posts / 0 new
Log in or register to post comments
Last post
Tue, 03/19/2019 - 19:25
#1
ericardo79
Offline
Joined: 03/07/2019 - 21:58
Specifying time range for extraction

Hi,
I am very new to IDEA and I have had extensive knowledge in other softwares.
Would any of you know how to specific time range? The purporse of this is to search for transactions out of the normal business hours.
If you could let me know, that will be great. Thank you!
 
EL

Top
Wed, 03/20/2019 - 00:07
ravisdxb
Offline
Joined: 01/13/2019 - 06:12

IDEA has a function @BetweenTime() for this purpose.
To find records between 9am to 5pm: @BetweenTime(TIME_COL,"09:00:00","17:00:00")
To find records outside of 9am to 5pm:  .NOT. @BetweenTime(TIME_COL,"09:00:00","17:00:00")

Top
Wed, 03/20/2019 - 01:48
ericardo79
Offline
Joined: 03/07/2019 - 21:58

it did work. Thanks!

Top