For the second find you just search for 4-2012. Or just 4 if you only have one year.
You could do:
Month (Get (CurrentDate) ) -2 & "-" & Year (Get (CurrentDate))
To find the records for the entire month 2 months ago.
Also, look here:
It's quite interesting.
How can you calculate dates to the day, but display them in years?
I just want to display how old they are in years, but only if they have reached the age in question.
If I have a calculation using “Year ( Get ( CurrentDate ) )” and “Year ( ChildDateofbirth )”, FMP calculates whole years. That is, it’s June now and for a child born in say, September 2010, they are shown as 2 years old – but they’re not yet.
To display the contents of a date field in different formats, use the data formatting found on the Inspector's data tab. You can format a date field so that just the month, the month and year or just the year is displayed.
To compute a person's age using the current date and their birth date would be done in an unstored calculation field with this expression:
Let ( T = Get ( CurrentDate ) ; Year ( T ) - Year ( DateOfBirth ) - ( Date ( Month ( DateOfBirth ) ; Day ( DateOfBirth ) ; Year ( T ) ) > T ) )
This subtracts 1 if this year's birthday is greater than today's date.