Report Formatting for Next Month Check

[Thedoc56]

I am trying to write a report that looks at a date in the database, compares the month to the current month + 1, and only shows records that meet the criteria and not all records. The expression will check a date ("POL_EFF&quot that is already in the database and add one month to it then show only records that comply. What am I doing wrong in my syntax?

If Month(Date) = Month("POL_EFF&quot
Then DateAdd("m", 1,Month( "POL_EFF&quot)
Thedoc

 

[mikey69]

You should be using the function "DatePart". Search the help file for details on syntax.

 

[cmmrfrds]

You can also use DateSerial

'the next month
DateSerial(Year(POL_EFF), Month(POL_EFF) + 1, 1)