How to create a Find Request for a dynamic Year?
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?
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".'