Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am pulling one date field from text file Which is like (171217) YYMMDD format.
But i am doubting whether qlik is treating it as Date or not.
Where can i check the data type (how can i change the type to Date)?
Thanks,
Muni.
Try this,
Date(Date#(DateField,'YYMMDD'),'MM/DD/YYYY')
Regards,
Kaushik Solanki
Hi,
Just load the data,
On sheet add the filter of that field.
If values are on right side it is number else it is Text.
Regards,
Kaushik Solanki
Thank you Kaushik.
I found it as number.
Now, how to change it to Date?
i tried in script Date(Datefield,'MM/DD/YYYY') but it is wrong dates.
Regards,
Muni.
Hi
Try this
date(date#('171217','YYMMDD'),'MM/DD/YYYY')
Regards
An Pham
Try this,
Date(Date#(DateField,'YYMMDD'),'MM/DD/YYYY')
Regards,
Kaushik Solanki
Thank you AN Pham.
Yours also Correct Answer. Thanks for your valuable time.
Thanks & Regards,
Muni.