Nextfullmonth

[celauritz]

Is there an easy way to do a select expert for the next full month as opposed to next30days. I have a report that has to be run late in the month for the next month, and it cannot be run on the same day every month.

 

[celauritz]

I tried this and it seems to work. Any reason why it shouldn't, or a better idea?

if month(currentdate) = 12 then
month({@Date}) = 1 and year({@Date}) = year(currentdate)+1 else
month({@Date}) = month(currentdate)+1 and year({@Date}) = year(currentdate)

 

[lbass]

Try:

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

-LB