AnsweredAssumed Answered

How to create a Find Request for a dynamic Year?

Question asked by FBrew on May 19, 2010
Latest reply on May 26, 2010 by comment_1

Title

How to create a Find Request for a dynamic Year?

Post

Filemaker 10.0v3 on Mac OS X 10.5 and Windows XP clients.

 

I am trying to create a button which will perform a Find. This button will be used every year. It needs to find student that entered the school after March 1 of the current year.

 

The button will perform a script. In the script, there will be a Extend Found Set command run. In that Extend Found Set command, the Find Request will include a greater than or equal operator (≥). 

 

How do I get the find request to find records after March 1 of the current year?

I tried:

Enrolldate ≥ 3/1/Year(Get(CurrentDate))

 

But I get the error message:

'The value of this field must be a valid date in the range of years 1 to 4000 and should look like "12/25/2003".'


Outcomes