Greetings.

I have a simple database which requires people to be contacted regularly for follow up. I do this by entering a follow up date.

I want FM to do an automatic search when I open the file of all followups due for that day and the next week.

I'm not sure whether to go by a calculation field, but suspect that I should (and have tried) to write an opening script to do the search but am not sure how to put it together.

Can someone help?

Thanks.

This will find all records which have DateField set to any date from current day to 6 days hence.

code:

---

Go to Layout [A_Layout_with_DateField_on_it]

Enter Find Mode <---Don't restore find requests

Insert Calculated Result [DateField, DateToText(Status(CurrentDate)) & "