Autocalendar not generated for Date field

[Jacob_Weig]

Hello, 

I have 3 different date fields of which only 2 are recognized in the Autocalendar. To load my data I have a script that looks like:

[table1]:
LOAD
[id] ,

...
Date(paid_date) as [paid_date],

...

where '2021-01-01'<[paid_date]<today();

my variable paid_date has some weird typos with a year of 0021, which is why I filter it out.

I added the date() so that it would be recognized in the autocalendar, but it is still not working. Can someone help me undestand why.

[rwunderlich]

Is there a "Derive fields..." statement in your script for [paid_date]?

-Rob

[Jacob_Weig]

@rwunderlich It worked! Thank you!