date range

[leburg]

Using cr8.5, I believe I understand how to use lastfullmonth, however is there a way to use it if the report is say, run in July
with June dates (1-30) and in such a scenario pull the last month as if you ran the report in June which would be the month of by May? In other words, inform lastfullmonth using an argument to then determine which last month you wish to see...

Any input would be appreciated.

Many thanks in advance.

 

[lbass]

Lastfullmonth can only be used for the last actual month. You can use dateserial to capture an earlier month, like this:

{table.date} in dateserial(year(currentdate),month(currentdate)-2,1) to
dateserial(year(currentdate),month(currentdate)-1,1)-1

-LB