Script to find records in current month, from last year

[Challenge440]

I am having some problems developing a button script that will find all records that are in the current month, from one year past. The field that it will search is a date field.

I am sure this is an easy fix for some, but I cannot seem to get my script to work.

Any help is greatly appreciated, thank you!

[comment]

Try:

Enter Find Mode []

Set Field [ Yourtable::Datefield ; [ Let ( [ t = Get (CurrentDate) ; m = Month ( t ) ; y = Year ( t ) - 1 ] ; Date ( m ; 1 ; y ) & ".." & Date ( m + 1 ; 0 ; y ) ) ]

Perform Find []

[Challenge440]

I feel like I understand the Button Setup wizard fairly well, but it asks me to change a lot of characters when I try to copy that script in. Is there another way to copy and paste a script in that I am missing?

Thanks for your help, I am slowly getting there and that process makes much more sense than my initial idea.

[comment]

It would be best to create a script first, then assign a Perform Script[] action to the button.

You cannot paste script steps from here to Filemaker, but you can paste the calculation formula (in blue) into the 'Specify calculated result' window of the Set Field[] step.