Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ctod bug
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00105986
Message ID:
00106096
Vues:
31
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform