Return to FileMaker.com
Script : Find Current month Record.
Hi, i am trying to create a button to search current month record.
Example today is 13th Feb 2012, when i click the button, it will show all the record for FEB2012.
And if today is 1 March 2012, when click the same button, it will show all the record for MAR2012.
Currently my button is using find date "*/2/2012, so i have to change the month number when every month comes.
Enter Find mode
Set Field using " Month ( Get ( CurrentDate ) )"
and perform find, but it doesnt work.
Any one can help me with this simple script?
Set Field [Yourtable::YourDatefield ; Month ( Get ( CurrentDate ) & "/*/" & Year ( Get (CurrentDate ) ) ]
Perform Find 
Retrieving data ...