>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
Right on the spot Walter. I got it just as short...
LastOfMonth=gomo(date, 1) - day(gomo(date,1))
Don't we all love these date one-liners :)