>>>
>>> >>> 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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement