Specifying time range for extraction

ericardo79

Forums

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

ravisdxb Wed, 03/20/2019 - 00:07

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")