Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor III

from 990101 to 01-01-1999

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

Hope this helps.

1 Reply
nagaiank
Valued Contributor III

from 990101 to 01-01-1999

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

Hope this helps.

Community Browser