Select in Field

[evansabres]

I have a field, 'Time' for which the values are formatted as 1:00 PM, 2:00 PM, etc.

I want to build  a text object with an action to select in field a few times. I want to select the values of 5:00 PM, 6:00 PM and 7:00 PM.\

I chose an action of 'Select in Field' and entered my field of Time and entered (5:00 PM|6:00 PM|7:00 PM) in the search string, but this produces no result

[sunny_talwar]

How do you create Time field in the script? Can you share the script you use to create it?

[evansabres]

Time is loaded in the script in the format in the same format that it is in the data, i just change the field name.

[Business Hour] as Time

[sunny_talwar · Accepted solution]

Try to load it like this

Hour([Business Hour] as Time

and then may be just this

'>=17<=19'