topic Help with date and age in QlikView

Help with date and age

Meg00 — Wed, 15 Feb 2012 08:18:47 GMT

Hi,

Im struggling to find a way to convert a number to date and then date to age. I have numbers that look like YYMMDDXXXX where Id like to use the date and from that get the age of the person. So first off, how du I exclude the last 4 numbers and add "19" to the year? And then how do I calculate age today from the date?

Pls help...

Help with date and age

marcos — Wed, 15 Feb 2012 08:32:21 GMT

this should do what you need

Date(Date#(LEFT(Date_Field,6),'YYMMDD')) AS New_Date
Age(Today(),Date#(LEFT(Date_Field,6),'YYMMDD')) AS Age_Field

Help with date and age

Meg00 — Wed, 15 Feb 2012 08:44:33 GMT

Seems to work!

Thank you!!

Help with date and age

CELAMBARASAN — Wed, 15 Feb 2012 08:57:55 GMT

Try with this expression

MakeDate(left(Field,2),Mid(Field,3,2),Mid(Field,5,2)) as Date

Age(Today(),MakeDate(left(Field,2),Mid(Field,3,2),Mid(Field,5,2))) as Age

Date(Date#('19'&LEFT(Field,6),'YYYYMMDD')) AS Date

Age(Today(),Date#('19'&LEFT(Field,6),'YYYYMMDD')) AS Age

Use the one which is comfortable for you

Celambarasan

Help with date and age

Meg00 — Wed, 15 Feb 2012 09:05:08 GMT

Yeah, that solved the problem with the year converting to 2000s instead of 1900s, thank you very much!