Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

from 990101 to 01-01-1999

Hi all,

How do I get a good qlikview date format from a number like 990401 (this means year 1999, month 4 and day 1)

I hope you can help me!

Kind Regards,

Martijn

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Date(Date#('990401','YYMMDD'),'MM/DD/YYYY') will return '04/01/1999'

Hope this helps.

View solution in original post

1 Reply
nagaiank
Specialist III
Specialist III

Date(Date#('990401','YYMMDD'),'MM/DD/YYYY') will return '04/01/1999'

Hope this helps.