Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Averaging date fields??
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00098244
Message ID:
00098249
Vues:
26
>>Hi everyone. I am sorry if this question has been addressed multiple times, but I couldn't find any references. All I want to do is simply obtain an average of a large set of date fields. Thanks for your help!
>
>Karl, check out CALCULATE command.
>
>Nick

To be more precise, you can use something like

CALC AVG(VAL(SYS(11,mydateField))) to nDateNumber
myAvgDate = CTOD(SYS(10,nDateNumber))

To get the average date look real there should not be records with empty dates.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform