Simple Script Find for Report

[dgieras]

I am a newbie to the Forum and a newbie to FM so please excuse the simplicity of this request.

I have a file with a field called Due Date. I need to create a Report via a script. I've created the report Layout..I just need the script structure that will allow me to Find all the records that are <= today's date, sort them by Due Date and display them ALL in the pre-defined Report layout that I've created.

Thanks

[Ocean West]

Create a calculation field that is = to the date field. The result of this new field should be Number. This will give you the numerical equivelant of the date (from 1/1/01)

Then in the script

Enter Find Mode

Set new field to "<=" & Status(CurrentDate)

Perform Find

[Keith M. Davie]

You may find this to be useful:

FileMaker / Support / TechInfo Article: 104055

http://www.filemaker.com/ti/104055.html