Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to include leap year (data from 29.02.2020 does get loaded)

Hi there

I have customer data stored in a Excel sheet. It is basically a order number and a delivery date.

Since 2020 is a leap year, the 29th of February (29.02.2020) exists but the problem is that it is not loaded from my script.

Is there a easy way to fix this?

Thanks, in advance!

my autoCalendar script looks like this:

date.PNG

 

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: How to include leap year (data from 29.02.2020 does get loaded)

Hi there

Why are you showing the autocalendar script? Are the autocalendar fields not derived for the 29 Feb dates or are the 29 Feb dates not loaded at all? If the entries for 29 Feb are missing then I don't think it's an autocalendar problem.

Regards,

Mauritz

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: How to include leap year (data from 29.02.2020 does get loaded)

Hi there

Why are you showing the autocalendar script? Are the autocalendar fields not derived for the 29 Feb dates or are the 29 Feb dates not loaded at all? If the entries for 29 Feb are missing then I don't think it's an autocalendar problem.

Regards,

Mauritz

View solution in original post