Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Go to Solution.
I have found the solution.Here is the trick.
Thanks for you support
Please find attached.
I have formatted date in 3 different format to show how it can be formatted.
The same method can be used at front end.
I never come across this issue past my experience. Can you provide more inputs related the same
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?
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]
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