Finding vaules in date field

[Steve Daines]

I have two fields a status field and a Date modified field, Can anybody help me create a script that will find the vaule of the status field that was modified more than 8 hours ago.

Example it would find all the records of status that have been "outstanding" for more than 8 hours

Regards

[cjaeger]

Try a calc

If(Status(CurrentDate)+Status(CurrentTime) >= date+time+(8*60*60);"outstanding";"less than 8 hours")