Find based on a date with a calculation

Followers

April 13, 200817 yr

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.

April 13, 200817 yr

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, 200817 yr by Guest
Removed file - unnecessary, I think.