SOLVED
Date Filter
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
david20100
8 - Asteroid
‎12-13-2016
01:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to use the date filter (or something with date) that everytime i run alteryx with the scheduler, it will take the actual day - 1 year - i can't do that with the date filter, if i manually choose today, in 5 days the date will be december 13th again
thanks
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
pcatterson
11 - Bolide
‎12-13-2016
02:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't know a way to do that, maybe thats something to add to the ideas area of the community.
RodL
Alteryx Alumni (Retired)
‎12-13-2016
03:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just use a Filter tool with DateTimeAdd(DateTimeToday(), -1, "year") as part of your expression...where the date field you are filtering on includes or excludes that (depending on your use case).
