GOMONTH(DATE(),-(YEAR(DATE())-1753)*12)

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

GOMONTH(DATE(),-(YEAR(DATE())-1753)*12)

Message

From

20/03/2000 07:42:33

Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States

17/03/2000 21:24:26

Doru Zamfirescu
Maple Ridge, British Columbia, Canada

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: GOMONTH(DATE(),-(YEAR(DATE())-1753)*12)

Miscellaneous

Thread ID:

00347376

Message ID:

00347800

Views:

>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?
>>

No, it's simply limited to 1753 and later because that's when the English-speaking countries standardized on the Gregorian calendar.

Tamar

Map

View

Click here to load this message in the networking platform