The FMP search is not a calculation engine. It cannot do the calc you are asking it to do. Also, FMP cannot use a variable as a search term. It will look for the variable name, not the value in the variable.
Use something like this:
Enter Find Mode 
Set Field ["date_field" ; "1/7/" & $lastyear & "...30/6/" & $year]
Perfom Find 
Ok that worked ty!
I was under the impression FM 11 and 12 could handle variables this way. my bad i guess.
I was under the impression FM 11 and 12 could handle variables this way
It can handle a variable (single), but not this way. It would have worked, if it went like:
set variable: $range: 1/7/$lastYear...30/6/$year
perform find: $range