I'm writing a script which contains the step Perform Find[]. I want to perform the find on a field called Year, which contains, obviously, year values. How can I get the current year value into this Perform Find? I could do it if I had access to a Calculation field with Year(Get(CurrentDate)), but it appears I don't.

Edited July 18, 200619 yr by Guest

Set Field[Year, Year(Get(CurrentDate))]

Specifying that calculation to find a record does not work. I know that is the correct calculation to get the current year, but how do I put in a Find request for the current year? If I ented any sort of calculation data into the find request, FileMaker does a literal search on "Set Field..." in the Year field.

Wait, I see now what T-Square meant. I was locking myself into constraining the found set, but I didn't realize I could do Enter Find Mode, Set Field instead. I learned something! :)

Elford--

Sorry I was so oblique. I should have given you more context. And yes, I meant put that step into your script, thus:

Enter Find Mode[]

Set Field[Year, Year(Get(CurrentDate))]

Perform Find[]

Cheers!