I have a report which asks for start date and end date.
I was using:
The First Day of Last Month:
%{DateSerial(DatePart("yyyy",DateAdd("m", -1, Date)),DatePart("m",DateAdd("m", -1, Date)),1)}%
The Last Day of Last Month:
%{DateAdd("d", -1, DateSerial(DatePart("yyyy",Date),DatePart("m",Date),1))}%
It fails with missing parameters. I deleted them and tried a hard coded date of 11/1/2018 & 11/30/2018, which is the exact format of the dates in the report. Still fails with missing parameters.
What am I missing?