Stephen,


>*-- last day of the current month
>mdate2=gomonth(date(),1)-day(date())

This would go wrong when the date = jan 31

this should be:
mdate2=gomonth(date()-day(date())+1,1)-1

Regards, Walter