topic Re: Problem with Date in App Development

Problem with Date

dineshraj — Fri, 02 Jun 2017 05:21:47 GMT

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 — Fri, 02 Jun 2017 05:51:28 GMT

Hi,

Please find attached.

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

kamal_sanguri — Fri, 02 Jun 2017 05:52:03 GMT

The same method can be used at front end.

Anil_Babu_Samineni — Fri, 02 Jun 2017 05:57:44 GMT

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

dineshraj — Fri, 02 Jun 2017 06:11:48 GMT

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 — Fri, 02 Jun 2017 06:11:52 GMT

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 — Fri, 02 Jun 2017 06:52:11 GMT

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 — Fri, 02 Jun 2017 07:20:39 GMT

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