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)?
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.
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.
Thank you AN Pham.
Yours also Correct Answer. Thanks for your valuable time.
Thanks & Regards,
Retrieving data ...