-
Re: Dates after year 2079 do not work
Mark Little Nov 29, 2017 8:52 AM (in response to jukah doanart)Hi,
I have just load your second script in my Qlik Sense and it loads fine.
I would check what your date format is set to in your load script.
Mine is SET DateFormat='DD.MM.YYYY'; - to match the base data.
Also i am on the latest version of sense
Mark
-
Re: Dates after year 2079 do not work
jukah doanart Nov 29, 2017 8:53 AM (in response to Mark Little )Hi!
Mine is SET DateFormat='DD.MM.YYYY';
I don't think this is the problem since it works with all years before 2079.
-
-
Re: Dates after year 2079 do not work
Mark Little Nov 29, 2017 8:57 AM (in response to jukah doanart)I am on the latest release of QlikSense.
I have copied your script and change the Date Format and it loads fine.
-
Re: Dates after year 2079 do not work
jukah doanart Nov 29, 2017 9:21 AM (in response to Mark Little )I am also on the latest version. Could you please post your app?
-
-
Re: Dates after year 2079 do not work
Ralf Becher Nov 29, 2017 9:29 AM (in response to jukah doanart)The LOAD should work like this:
Date(Date#(Start_Date,'MM.DD.YYYY')) AS Start_Date,
Date(Date#(End_Date,'MM.DD.YYYY')) AS End_Date
-
Re: Dates after year 2079 do not work
jukah doanart Nov 29, 2017 9:32 AM (in response to Ralf Becher )Thanks for the suggestion, but it does not help :/
-
Re: Dates after year 2079 do not work
Ralf Becher Nov 29, 2017 9:33 AM (in response to Ralf Becher )it's wrong formatted:
Date(Date#(Start_Date,'DD.MM.YYYY')) AS Start_Date,
Date(Date#(End_Date,'DD.MM.YYYY')) AS End_Date
-
Re: Dates after year 2079 do not work
jukah doanart Nov 29, 2017 9:36 AM (in response to Ralf Becher )Yes, I saw that and tried like this, not helping.
-
-
-
Re: Dates after year 2079 do not work
jukah doanart Nov 29, 2017 9:39 AM (in response to jukah doanart)I can confirm now that if the date is until 18.01.2080 everything works perfectly with my script.
If the date is 19.01.2080 and later, the problem appears.
-
Re: Dates after year 2079 do not work
Ralf Becher Nov 30, 2017 7:50 AM (in response to jukah doanart)Yes I can rebuild the issue. It seems to be that a field containing a date > 18.01.2080 gets not tagged with $date. This is a bug!
-
-
Re: Dates after year 2079 do not work
Johanna Truong Nov 30, 2017 10:06 AM (in response to jukah doanart)Try adding tag field EndDate with '$Date'; to your script.
Its a workaround but I hope that it will solve your issue!
/J
-
Re: Dates after year 2079 do not work
jukah doanart Dec 1, 2017 7:12 AM (in response to Johanna Truong )Hello, thanks, this is it!
Btw. does it make any difference if there are single quotes or not:
TAG FIELDS End_Date WITH '$date';
TAG FIELDS End_Date WITH $date;
Both seem to work.
-