Find yesterday

[LarryLogic]

I need a script that will automatically find all records that were created yesterday. I have a record that is creation date. I may or may not have records for today. I can't seem to find the right find request.

Larry

[-Queue-]

Enter Find Mode[ ]

Set Field["creationdate", "Status(CurrentDate) - 1"]

Perform Find[ ]

[LarryLogic]

Thanks that does it, but, I am trying to use If(Hour("TextToTime"(CurrentTime))<4 to find out if it's after midnight (before 4 AM) or not. If after Midnight I need Today and Yesterday and if before midnight just today.

Larry

[-Queue-]

Enter Find Mode [ ]

If [Hour( Status(CurrentTime) ) < 4]

Go to Layout {one with creationdate on it}

Insert Calculated Result [select, "creationdate", "DateToText( Status(CurrentDate) - 1 ) & "..." & DateToText( Status(CurrentDate) )"]

Else

Set Field ["creationdate", "Status(CurrentDate)"]

Perform Find [ ]

[LarryLogic]

The Hour, Status is what I needed.

I should have asked 8 hours ago.

Thank you

Larry