Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rathnam_qv
Not applicable

Date issue?

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.

1 Solution

Accepted Solutions
kaushik_solanki
Not applicable

Re: Date issue?

Try this,

Date(Date#(DateField,'YYMMDD'),'MM/DD/YYYY')

Regards,

Kaushik Solanki

5 Replies
kaushik_solanki
Not applicable

Re: Date issue?

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

rathnam_qv
Not applicable

Re: Date issue?

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.

kenphamvn
Not applicable

Re: Date issue?

Hi

Try this

date(date#('171217','YYMMDD'),'MM/DD/YYYY')

Regards

An Pham

kaushik_solanki
Not applicable

Re: Date issue?

Try this,

Date(Date#(DateField,'YYMMDD'),'MM/DD/YYYY')

Regards,

Kaushik Solanki

rathnam_qv
Not applicable

Re: Date issue?

Thank you AN Pham.

Yours also Correct Answer. Thanks for your valuable time.

Thanks & Regards,

Muni.