Find based on a date with a calculation

[Jed69]

Hi.

I have a find in a script to meet a number of criteria. Firstly I enter find mode, then I set the relevant fields with a set field command and then I do the perform Find. It works great. I would however like to add one more criteria onto my find. It would be to see if the current date is at least five days after a date in a field. Not quite sure how the best way around this would be. Anyone have any suggestions.

[LaRetta]

Do you mean that you only want to find records which meet the criteria you've specified AND that their date is 5 days or older from today? The it would be:

Set Field [ theDate ; " :less: " & Get ( CurrentDate ) - 5 ]

If you mean that you only want to perform the find if a DIFFERENT date is at least 5 days older than the current date, it should be the same but it would depend upon whether it is a related date, an independent preferences date or what.

LaRetta :wink2:

Edited April 13, 2008 by Guest
Removed file - unnecessary, I think.