Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Calculate Age from evar which contains month and year.

Avatar

Community Advisor

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

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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.

Avatar

Community Advisor
What if If I store month as number and year as number?

Avatar

Community Advisor

@Luca_Lattarini how can you store a number in an eVar when AA doesn't allow numbers to be stored?

Screenshot 2021-01-12 at 4.04.18 PM.png

Avatar

Level 10
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?