Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GOMONTH(DATE(),-(YEAR(DATE())-1753)*12)
Message
From
17/03/2000 21:58:32
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00347376
Message ID:
00347394
Views:
23
>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
Map
View

Click here to load this message in the networking platform