Getting information of one or two specific years

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.

Workflow

Datasets

Input

Date Time

Help

In Database

In-Database

Accepted answers

Qiu

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

0617-neromerob.yxmd

All comments

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

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

0617-neromerob.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703