I have a date field in my table that is formatted DD-MMM-YY and I have to make a query that pulls up all the records in certain months (All the records with a January date, all the records with a February date, etc.) but I'm having trouble with how to do that. I'm pretty sure I need to make a parameter asking which month I want to pull up but I'm lost after that. Any ideas?
Actually, I have to do that on a calculated field now and it's not working because I don't know what to put in as the "Field". I tried putting the actual calculation in there but it didn't work. Any ideas?