This was Jim Booth's solution.

Vlad

>How about this one? It doesn't matter what SET DATE settings are.
>
>goMonth(tdDate, 1) - day(goMonth(tdDate, 1))
>
>Biju
>
>>
>>
>> >I haven't been around for a while...how about:
>> >
>> >? (date()+32) - day(date()+32)
>> >
>> >Bill
>>
>> Bill, I've been following this thread for quite a while and I have to say
>> that your method is most awesome! I tried it with every month and it worked
>> excellent.
>>
>> KUTGW