Scripting with date field?

[BobWeaver]

Try this script:

code:

---

Enter Find Mode

Set Field [YourDateModifiedField, Calculation: Date(

Month(Status(CurrentDate))-1,

Day(Status(CurrentDate)),

Year(Status(CurrentDate)))]

New Record/Request

Set Field [YourDateModifiedField, Calculation: Date(

Month(Status(CurrentDate))-6,

Day(Status(CurrentDate)),

Year(Status(CurrentDate)))]

Perform Find

---

Make sure "restore find requests" is un-checked.

Also see this topic regarding calculating with dates:

http://www.fmforums.com/ubb/Forum15/HTML/000282.html

[This message has been edited by BobWeaver (edited January 30, 2001).]

[612web]

I have a date field already in my filemaker database and I need to write a script so that I can do a find every morning. I would like the result of this to display the records that were modified one month ago to the day as well as the records that were modified 6 months prior to the day. How would I go about doing this?

Sorry if this is simple, you are dealing with a rookie script writer here haha

thanks for any help anyone can give