hello to everyone.
I would like to know how to get data from one specific year, I know there is a filter tool but not quite sure how it works.
I would like to get only the records from 2018 for example.
And also get records from two different years (Example 2018 and 2022).
Thank you.
Solved! Go to Solution.
Assuming that the date field is already set as Date type, you can have the expression below on a filter tool:
DateTimeYear([Date]) = 2018
@neromerob
We can use a DateTimeFormat function to convert the data to Year in a string format then do the filtering.
Hey @neromerob,
The above solutions posted by @gabrielvilella and @Qiu should work perfectly. Thought this will be an extremely helpful resource for you as you explore all the DateTime Functions available in Alteryx ☺️: