Jump to content

Scripting with date field?


This topic is 7865 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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).]

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

This topic is 7865 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.