AnsweredAssumed Answered

Finding records older than a day issue.

Question asked by xxx202xxx on Aug 29, 2017
Latest reply on Aug 29, 2017 by Jens Teich

All, I am having trouble with a timestamp field where I am trying to find records older than a day.  Stepping through the debugger nothing is found.  I see where Pending is entered and 8/29/2017 0:*:* is entered for modified_time.

 

Here is my script:

 

Set Error Capture [On]

Go to Layout [Service_Management]

Enter Find Mode [Pause:off]

Set Field [Status:Pending]

Set Field [Modified_Time; >= (Get (CurrentTimestamp) - 1 * 24 * 3600)]

Perform Find

Outcomes