Problem with Date

[dineshraj]

Hi Experts

I have stuck in a problem with date. My Date Field is 10-05-17 which is 10-May-2017.But Qlik take it as 17-05-2010(17-May-2010).

How to resolve this issue?

Immediate reply Appreciated

Thanks in Advance

Dineshraj

[kamal_sanguri]

Hi,

Please find attached.

I have formatted date in 3 different format to show how it can be formatted.

[kamal_sanguri]

The same method can be used at front end.

[Anil_Babu_Samineni]

I never come across this issue past my experience. Can you provide more inputs related the same

[dineshraj]

Hi Anil,

Actually there is problem with my data. In excel sheet they use the wrong format.

Format should be (dd-mm-yy) but it is (yy-mm-dd).

Is data format can be changed by Qlik?

[jonathandienst]

You can convert dates with a specific format from strings to numeric date values in your load script like this:

Date(Date#([My Date Field], 'dd-MM-yyyy')) as [My Date Field]

[dineshraj · Accepted solution]

Hi all,

I have found the solution.Here is  the trick.

Date(Date#(text(Date([Date Field],'DD-MM-YY')),'YY-MM-DD')).

Thanks for you support

[Anil_Babu_Samineni]

Yes, By help of only Date and Date#

Date(DAte#(FieldName, 'YY-MM-DD'), 'DD-MM-YY')

Note: Seems, You found answer. You can mark your answer as correct