Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Determining age based on dob
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00592860
Message ID:
00593371
Vues:
25
>Right you are. That'll teach ME to spew something off the top of my head. . .
>
>JR
>
>>Shouldn't it be 365.25?
>>
MyDOB ={^1963-08-30}
>>? ROUND( (DATE() - MyDOB) / 365.25, 1)
>>
>>
>>
>>>Are you sure your dob field is truly a date field? It seems that you should have gotten the number of days since the dob with that command (not what you were after, but better than an error).
>>>
>>>Do this
>>>MyDOB ={^1963-08-30}
>>>? (DATE() - MyDOB) / 364.25
>>>
>>>That should give you what you want.
>>>
>>>JR
>>>
>>>
>>>>How can I create an expression in expression builder to get a age of person based on their date of birth. For example:
>>>>
>>>>Dob          Age
>>>>10/25/44     53.4
>>>>
>>>>
>>>>I tried the expression (date()-person.dob) but it gave me an error as Ambigious date/datetime contstant. Is it even possible to find number of years and months in expression
>>>>
>>>>
>>>>Thanks
>>>>Nick Patel

It worked, thank you for your help

Nick Patel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform