Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Date(Date#('990401','YYMMDD'),'MM/DD/YYYY') will return '04/01/1999'
Hope this helps.
Date(Date#('990401','YYMMDD'),'MM/DD/YYYY') will return '04/01/1999'
Hope this helps.