First day of the month that previous to lastfullmonth 1

[Corres]

CRXI

I need to remove parameters {?Year},{?Month} from the report and use lastfullmonth function to run and distribute report in InfoView.

I have the following selection formula in one of subreports which displays data for selected month plus the previous month (2 month range):

{INCIDENT.INC_RESOLVE_ACT} in {@Last Period Start Date} to Date ({?Year},{?Month},{@Last Day})

{@Last Period Start Date} is a first day of the month that previous to the selected month
{@Last Day} is the last day of the selected month

I tried to change it:
{INCIDENT.INC_RESOLVE_ACT} in {@Last Period Start Date} to maximum(lastfullmonth)
but I do not know how to catch the first day of the month that previous to lastfullmonth.

Please give me idea how to accomplish this? Thank you!

 

[pmax9999]

Try:

DateSerial(Year(CurrentDate), Month(CurrentDate)-2, 1)

When run in July, it returns 1 May. Is that what you are looking for?

Cheers
Pete

 

[Corres]

Thanks Pete for your time! I believe it should work. I will let you know tomorrow! Cheers,

 

[Corres]

Thanks once again Pete, it works well. I have used it to modify other formulas as well.

Cheers!