Unanswered: newbie question: query only the records are in current month
I've tried out in query's criteria of date filed: "month(now())", but it not works.
Could you guide me how to query only the records of current month?
In case of this month: I only want the record for August. But in case of next month, I only want the records for September.
many thanks. I need your help.