Mark,
Sorry, but I think your more complex function is much harder to understand.
Using GOMONTH is very easy.
>thanks Naomi. I was hoping that there was a built in FP one, ended up doing this
>
>CTOD("01/" + IIF((MONTH(mx) + 1)>12,'01',ALLTRIM(STR((MONTH(mx) + 1)))) + "/" + ALLTRIM(STR(YEAR(mx)))) - 1
>
>but some of the functions in the FAQ look neater :)
>~M
>>>hi,
>>>is there a routine that returns the last day of the month? something like lastdayofmonth(date()) giving me 31 for the month of august etc. I could write a routine but thought i saw one before but cannot find it.
>>>~M
>>
>>GoMonth(date(MyYear, MyMonth,1),1) -1
>>
>>See also
Some useful date functions FAQ #7661
If it's not broken, fix it until it is.
My Blog