Hi,

FWIW this will also give the date of the last day of the month:

LastDayOfMonth =  GOMONTH(DATE(),1)-DAY(GOMONTH(DATE(),1))

But, as I think you realised, this type of solution will not work unless the code is run *every* day. Your best bet is probably to follow Hilmar's suggestion and use a table with end of month dates and a flag indicating whether that particular monthly report has been printed.
HTH,
Viv

>thanks hilmar your helpful reply, but i have a question, if last date on leave day(sunday etc).how to changes this.
>
>I want to print a report.
>

>If month(date()+ 1) # month(date())
>print from 1st report
>else
>report from 2nd report