Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GOMONTH(DATE(),-(YEAR(DATE())-1753)*12)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00347376
Message ID:
00348072
Vues:
30
>Well, I think it would be kinder if the limitation were documented <g>.

Right!


>If you mean, why doesn't the same thing happen with straight date math (e.g., {02/19/1700}-365 ), then I wouldn't hazard a guess. FP2.6 claims to have "worked" with dates as far back as 100AD but in VFP it goes back to 1 Mar 0000, the day before which was 0 Mar 0000 <g>. The whole idea of a reliable Julian or Gregorian date back that far is just laughable anyway.

The calendar is such a horrible mess if you look closer! I don't think it (the mess) can be addresed by FP functions, and I think GOMONTH() should ignore the 1753 border (which, BTW, was 1924 for Eastern Europe!).


>>> True, it is date math though. I mean, if you don't use gomonth(), what would be the birth
>>> date for somebody "Died 30 May 1899 at age 1 month"?
>
>That particular example probably wouldn't generate much debate. Most would conclude a birth date of 30 April 1899.

I was thinking "Died 30 March 1899 at age 1 month"?, it doesn't matter anyhow, I got your points.


>If you need help writing such a function, then write to me by e-mail and describe what you're trying to accomplish exactly. I'll see what I can do to help.

Thank you for the offer, hopefully I’ll never need it :)
Doru
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform