Dates after year 2079 do not work

[jukah_do]

Hi all,

I have weird problem with my dates. When I use this script combined with autoCalendar I get the date fields derived as expected:

Data:
Load
Document,
Date(Start_Date,'MM.DD.YYYY') AS Start_Date,
Date(End_Date,'MM.DD.YYYY') AS End_Date
Inline
[
Document,Start_Date,End_Date
A,05.10.2015,31.12.2055
B,12.10.2016,31.12.2079
C,06.06.2017,31.12.2079
]
(Delimiter is ',');

However, if a date is in year 2080 or later, Qlik Sense does not generate the date field:

Data:
Load
Document,
Date(Start_Date,'MM.DD.YYYY') AS Start_Date,
Date(End_Date,'MM.DD.YYYY') AS End_Date
Inline
[
Document,Start_Date,End_Date
A,05.10.2015,31.12.2055
B,12.10.2016,31.12.2079
C,06.06.2017,31.12.2080
]
(Delimiter is ',');

Any idea what is going on here? Thanks!

[rbecher]

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!

[Anonymous · Accepted solution]

Try adding tag field EndDate with '$Date'; to your script.

Its a workaround but I hope that it will solve your issue!

/J

[jukah_do]

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.