Month to date issue

[celauritz]

I have a bunch of daily reports that I run using monthtodate.

The problem I have is that currently, I have to copy all these reports and change monthtodate to lastfullmonth to run them on the first, so I get the information for the previous month.

Is there some type of selection formula that would run the lastfullmonth on the first of the month and monthtodate on the current month?

 

[lbass]

Try a selection formula like:

(
day(currentdate)=1 and
{table.date} in lastfullmonth
) or
{table.date} in monthtodate

-LB