Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to load it like this
Hour([Business Hour] as Time
and then may be just this
'>=17<=19'
How do you create Time field in the script? Can you share the script you use to create it?
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
Try to load it like this
Hour([Business Hour] as Time
and then may be just this
'>=17<=19'