We run a report every month.. 1-15th and then 16th-EOM..
I want to have the report calculate the start & end date parameter based on the day..
So if I open the report between the 1-15 it will put for this month.. 11/1/2015 start date and 11/15/2015 end date. After the 15th.. 11/16/2015-11/30/2015 (EOM).
I was going to use an iif statement to find the day then use something like this.
=FormatDateTime(DatePart("m",Now()) & "/16/" & DatePart("yyyy",Now()), DateFormat.ShortDate)
when I put that in the expression of the parameter I get an invalid type.
Any help is appreciated. Thanks.