finding dates

[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

[Mark Appleby]

Find All Records then run a find in the date field type"<= //" excluding quotes then create a script called find records today and earlier then then script the find.

[mhudd]

I tried funning a find using your suggestion of <= // however, Filemaker returns "The date in this field must be a valid date in the range..."

Am I doing something wrong?

[Vaughan]

Try scripting the process, and use <= Status(CurrentDate)

[Kremlarkin]

This post is WAY late given when the original question was posted. Anyway, when Mark Appleby suggested using "<= //" to find all dates equal to and before today, the reason filemaker barfed at you was the space between the "=" and the "//" terms. Just remove the space and you will end up with "<=//", which should work.