General information
Category:
Coding, syntax & commands
>Sorry, wrong cut & paste!
>
>?GOMO(DATE(),-(YEAR(DATE())-1753)*12) returns the correct day
>
>but
>
>?GOMO(DATE(),-(YEAR(DATE())-1752)*12) returns an empty date.
>
>
>>>Is this a bug?
>>
>>It looks ok to me. It will keep the same month and day and place whatever year you put in place of '1753'.
>>
>>What were you expecting?
I also get an empty date if I issue
GOMONTH( 12/31/00, -2976 )
This would take it into 1952.
But
GOMONTH( { 01/17/1953 }, -1 )
works properly
Looks like a bug.
Previous
Next
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