How to do a summary data by month if the field format is mm/dd/yyyy
I need you help.
I want to do a report which shows the total student enrolled number of each month, and it bases on the student enrolled date. But on the enrolled date field, I set up the format is mm/dd/yyyy which I have to(I use calendar).
So, how can I do the number of student enrolled by month on query and show on the report?