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

[qlik_user2]

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:

[Mauritz_SA · Accepted solution]

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