
Contributor III
2022-04-05
04:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Autocalendar not generated for Date field
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.
590 Views
2 Replies


Partner Ambassador/MVP
2022-04-05
07:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a "Derive fields..." statement in your script for [paid_date]?
-Rob

Contributor III
2022-04-06
03:46 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@rwunderlich It worked! Thank you!
559 Views
