Qlik Community

Qlik Sense App Development

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

dineshraj
Contributor

Problem with Date

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

1 Solution

Accepted Solutions
dineshraj
Contributor

Re: Problem with Date

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

7 Replies
kamal_sanguri
Valued Contributor

Re: Problem with Date

Hi,

Please find attached.

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

kamal_sanguri
Valued Contributor

Re: Problem with Date

The same method can be used at front end.

Re: Problem with Date

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

dineshraj
Contributor

Re: Problem with Date

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?

MVP
MVP

Re: Problem with Date

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
Contributor

Re: Problem with Date

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

Re: Problem with Date

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

Community Browser