Transact Time flag

[danielnevitt]

Dear all,

I would appreciate some help with the best way to flag timestamps between a range.

For example I have a field TransactTime and I would like to report all TransactTime's between 23:00 - 06:00.

Any help would be great.

Regards,
Daniel

[sunny_talwar]

Does this field only include time or is it made up of date and time both?

[danielnevitt]

Hi Sunny,

The field contains date and time.

Thanks,
Daniel

[sunny_talwar · Accepted solution]

May be create a flag like this

If(Frac(TransactTime) >= MakeTime(23) or Frac(TransactTime) <= MakeTime(6), 1, 0) as TimeFlag