MonthName(Get(CurrentDate)+60) & " " & Year(Get(CurrentDate)+60)
I assume your formula used a date field which you can subsitute with the Get (currentDate). I used the above calculation field with text format and this field is searchable.
You don't need GetAsText in that calculation.
Just set up a calculation field with Date + 60 and select "Date" as the return type.
Use data formatting to have the field display only the month name and the year.
To perform a find for all records with a specific date and year, just enter this criteria:
to find all records for the month of March 2013.
Thanks both for the assist, I tried both versions out but opted for Phil's in the end as it seemed the quicker fix. My find works perfectly now, didn't realise you could search by month and year without having to put a day at the front so will be using this more often in other searches. Thanks again!
I didn't realize either that you could search a date field by month and year only - I just tried it in a simple date field formated to 8/8/13, with criteria, "5/2013", and I get the standard message telling me how dates need to be entered. Is this because the field was not a calculation field?
I should also mention that this is FMP 5.x, client will be moving to FMP12 with installation of new computers.
I would guess that you were not in find mode.
Not only can you enter month/year, you can enter just the year.
You can even enter Tuesday and find all dates that fall on a Tuesday....
But you have to be in find mode or you'll get a validation error when you exit the field.
Actually, I was in Find mode, and just tried it again to confirm to myself. I looked for just May, just 2013, and as my first post. The message appears every time. Could it be FMP 5?
Yes. My answers have been in the context of recent versions of FileMaker. FileMaker 5 is very old and there have been many changes made since that version.