Irregular Date format

[ankit777]

Hi All

I have date format like shown below. How should I read this in QV.

Date:  

14/5/2016

04/05/16

29/4/2016

01/05/16

30/4/2016

31/5/2016

29/4/2016

27/4/2016

03/05/16

30/4/2016

[Kushal_Chawda]

I think if Date coming as string then we need to use Date# only.. SET will not be able to recognize the format

[Chanty4u]

hI

CHK THIS

[sunny_talwar]

I am going to test that out right now

[Chanty4u]

yes kush set is not working

[sunny_talwar]

Check out the attached:

SET DateFormat='DD/MM/YYYY';

Table:

LOAD Date(A) as Date

FROM

Community_217289.xlsx

(ooxml, no labels, table is Sheet1);

Excel

QV

[Chanty4u]

i dnt know why it is not workng for me

[Kushal_Chawda]

Looks ok, but I still have doubt, otherwise Date# function would no longer be available in QlikView to interpret string values as Date

[sunny_talwar]

Well it would be still needed when formats are like this

25/01/2016

01/25/2016

This cannot be handled without Alt()

but it seems this can:

25/01/2016

25/01/16

[Kushal_Chawda]

Need to test on other sources as well.

[sunny_talwar]

Other source?