Calculate Age from evar which contains month and year. | Community
Skip to main content
Luca_Lattarini
Level 9
Jan 8, 2021 8:47 AM UTC
Solved

Calculate Age from evar which contains month and year.

Hello everyone,

 

I have an evar which stores 10/1982 as birth date. Is it possible to create metric which gives the current age?

Thanks

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
yuhuisg
yuhuisgAccepted solution
New Participant
Jan 9, 2021 6:51 AM UTC

eVars store their values as text. So unfortunately, there's no way to convert that text string into a date that AA can calculate on.

Even if you classify the eVar's date string to "Year", that Year would still be a string that AA cannot calculate on.

4 replies

jantzen_b
Employee
Jan 25, 2021 8:08 PM UTC
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?
Translate
yuhuisg
yuhuisgAccepted solution
New Participant
Jan 9, 2021 6:51 AM UTC

eVars store their values as text. So unfortunately, there's no way to convert that text string into a date that AA can calculate on.

Even if you classify the eVar's date string to "Year", that Year would still be a string that AA cannot calculate on.

Translate
Luca_Lattarini
Level 9
Jan 12, 2021 4:56 AM UTC
What if If I store month as number and year as number?
Translate