2 months ago 1

[pungigi]

I have some reports that will need to be run on the 13th of every month for 2 months ago, example, March 13th will run for January data, April 13th for February data etc.... Can anyone help me figure out a formula for this??? I can get it to run LASTFULLMONTH but thats about it.

 

[lbass]

Try something like:

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

-LB

 

[synapsevampire]

There are several ways, this is a simple one:

In the Report->Edit Selection Formula->Record (this is software version dependent which you didn't bother to post) place something like:

{table.field} >= dateserial{year(currentdate),month(currentdate)-2,1)
and
{table.field} <= dateserial{year(currentdate),month(currentdate)-1,1)-1

-k