Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is there a "Derive fields..." statement in your script for [paid_date]?
-Rob
@rwunderlich It worked! Thank you!