Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
cjett7769
Contributor II
Contributor II

Is there away to create a field to show the Date a person turned 18

I was wonderful if there is a way in Qlikview to show the date when a client turned 18. For the app I am creating its important that we have a field that shows the date someone turned 18. Any help would be very much appreciated.

1 Solution

Accepted Solutions
sunny_talwar

Do you have Date of Birth? If you do, then may be this:

LOAD Client,

          Date(AddYears([Date of Birth], 18)) as Turned18

FROM Source....;

View solution in original post

1 Reply
sunny_talwar

Do you have Date of Birth? If you do, then may be this:

LOAD Client,

          Date(AddYears([Date of Birth], 18)) as Turned18

FROM Source....;