AnsweredAssumed Answered

confusion on search, intended to find recent changes

Question asked by StevenBland on Sep 27, 2010
Latest reply on Sep 28, 2010 by philmodjunk

Title

confusion on search, intended to find recent changes

Post

The record have a field, last edit date, which is a timestamp that has the last edited timestamp of that record. As a search, I wanted to see which records have changed in the last 60 minutes, so a simple script

Enter Find Mode []

Insert Calculated Result[ Select; Planner:: Last Edit Date[">"&Get( Current Timestamp ) - 3600]]

Perform Find []

should return those records that have changes in the last 60 minutes? or am I missing something simple?

it always seems to be an empty set, even with obvious records with a timestamp in the last 60 minutes

Outcomes