I have a field DueDate in reports table.
I need to write a query that will return all records with a due date that falls in the next month from now.
So, if it is Jan. 14, I want all records that are due in the month of Feb.
In the criteria of the DueDate field, would I have:
=Datepart(“m”,Date())+1)