Is there a way to calculate the last date of the previous month using the date formula (@statementdate) to suppress report detail?
Currently, I have to change this formula manually every month and would like for it to calculate automatically from the statement date. see attached.
Statements are printed on the first on the month for the previous month, i.e. Jan 1,2014 we'll print statements for December 2013, but I do not want to show discount information prior to Nov 30,2013. (11/30/2013 is the date I need to calculate from the statement date 01/01/2014)