Getting information of one or two specific years

[neromerob]

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. 

[gabrielvilella]

Assuming that the date field is already set as Date type, you can have the expression below on a filter tool:

DateTimeYear([Date]) = 2018

[Qiu · Accepted solution]

@neromerob 
We can use a DateTimeFormat function to convert the data to Year in a string format then do the filtering.

[Adrian_T]

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 ☺️:

https://help.alteryx.com/20221/designer/datetime-functions