date field search script

[mhudd]

I have a date field and I want to create a script that returns all records that contain "today's date" and all dates prior.

I appreciate your help!

Michael

[mhudd]

Ken Thank You! Perfect!

[kenneth2k1]

Hello Michael:

I think this is what you need:

Enter Find Mode [ ]

Go to Layout ["layout that field is on"]

Insert Calculated Result [select, "Date Field", ""<=" & "datetotext(Status(Current Date))"]

Perform Find [ ]

Go to Layout [original layout]

Let me know how it works

Ken