New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
New Contributor II

Help with date and age

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...

Tags (2)
1 Solution

Accepted Solutions
MVP

Help with date and age

Hi

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

or

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

4 Replies
New Contributor III

Help with date and age

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

New Contributor II

Seems to work!

Thank you!!

MVP

Help with date and age

Hi

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

or

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

New Contributor II

Help with date and age

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