Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ctod bug
Message
From
08/06/1998 18:06:09
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00105986
Message ID:
00106096
Views:
32
>Hi Derk,
>
>There was a thread on this issue a year or so ago here on UT. The consensus seemed to be as follows: Fox can store dates from 01/01/0100 through 12/31/9999, but some of the date functions do not always work with dates prior to a certain time. For example, in my own admittedly non-rigorous testing with VFP 5.0a, GOMONTH(date, 12) returns " / / " for any date prior to 01/01/1752, but GOMONTH(date, 120) works with dates back to 01/01/1743.
>
>My understanding is that the Gregorian calendar replaced the Julian calendar in 1582, at which time several changes were made that mess up the "how many days between two dates" type of calculation for dates than span that year. So it's understandable why some of VFP's date calculations would not work for dates prior to 1582, but I don't know what the significance of 1752 or 1743 is.
>

Turns out that GOMONTH(date, 1200) works with dates back as far as 01/01/1653. So the significant factor seems to be that the result of the GOMONTH calculation has to be 01/01/1753 or greater.
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform