>>>
>>> >>> 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)
Just a small tip: You don't need CTOD here, just use {1997/03/31}.
Vlad
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only