FM Pro 6 Wind. XP

I want to have scirpt that perform these step for me

- When I open the file

- Go to the date field to search

- then find them

- Then print them out for me

In Document Perferences I have checked tho box Perform Scirpt when opening file

My Script

Go to Layout [Form PM]

Go to Field [Last PM]<--------(Date Field and every record has a same field)

If [Last PM<= Today]

Perform Find [Restore find request, Replace Found Set]

Print Setup [Restore Setup option, no dialog]

Print [No dialog]

End if

Somehow it does not work. Am I do some thing wrong?

Please help

Thanks

Regards,

NewtoFM

Create a new global field and try this. Do not use the Today function. Use Status (CurrentDate) instead. The Today function is quirky and no longer supported in future version of FM.

Go to Layout [Form PM]

Set Field [gFindStorage, Last PM]

If [gFindStorage <= Status ( CurrentDate )]

Perform Find [Restore find request, Replace Found Set]

Print Setup [Restore Setup option, no dialog]

Print [No dialog]

End if

John,

Thank you for reply.

I still do not understand how to define the new global field, I tried set data type for TEXT and DATE either way it did not work.

Please help

Regards,

NwetoFM

In your define fields screen, you will see a fiel type of global. Create a global with text data type.

John,

gFindStorage you metioned above is the new global field ?

Regards,

NewtoFM

Yes.

Thanks.