>>
>> >>> I see. In that long discussion, there were 2 solutions in just one
>> >>> line
>> >>> (one formula) that don't depend on the SET DATE. This is why I asked.
>> >>> I
>> >>> thought you found some errors.
>> >>
>> >>BTW: The second method (Jim Booth mentioned one) was:
>> >>
>> >>? gomonth(date()-day(date())+1,1)-1
>> >
>> >Yours or mine? :) Mine doesn't have the question mark... :)
>> >
>> >Vlad
>>
>> I haven't been around for a while...how about:
>>
>> ? (date()+32) - day(date()+32)
>>
>> Bill
>>
>> P.S. I haven't looked further down the thread...maybe this has already
>> been brought up...
>
>Hi Bill,
>This is the most excellent method I have ever seen! Good ideas
>should be appriciated!!!
>
>Regards,
>Biju
Sorry but did you try with
? (cTOD("1997/01/31")+35) - day(cTOD("1997/01/31")+35)
? (cTOD("1997/01/31")+32) - day(cTOD("1997/01/31")+32)
? (cTOD("1997/01/30")+32) - day(cTOD("1997/01/30")+32)
? (cTOD("1997/01/29")+32) - day(cTOD("1997/01/29")+32)
? (cTOD("1997/01/28")+32) - day(cTOD("1997/01/28")+32)
? (cTOD("1997/01/27")+32) - day(cTOD("1997/01/27")+32)
? (cTOD("1997/07/31")+32) - day(cTOD("1997/07/31")+32)
? (cTOD("1997/12/31")+32) - day(cTOD("1997/12/31")+32)
? (cTOD("1997/03/31")+32) - day(cTOD("1997/03/31")+32)