How to use a filter

[Adam-Adam]

Hi All,

Basic question, how do I use a filter.

The goal is to filter by 18 months prior to today's date.

What is the formula I enter in "Custom Filter"

Thanks

[Adam-Adam]

Follow up remark.

Could I also get the "Custom Filter" for:

12 months to 3 months ago today

i.e. 04/07/2021 - 04/07/2022

Thanks

[Felipe_Ribeir0]

Hi @Adam-Adam 

Take a look at the attached workflow.

1) The goal is to filter by 18 months prior to today's date:

[Date] >= DateTimeAdd(DateTimeToday(), -18, 'months')

2) 12 months to 3 months ago today:

 [Date] >= DateTimeAdd(DateTimeToday(), -12, 'months') and [Date] <= DateTimeAdd(DateTimeToday(), -3, 'months')

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[binuacs]

@Adam-Adam one way of doing this with the DateTimeAdd function. you can find the details in the below link

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

[Felipe_Ribeir0]

Hi @Adam-Adam 

It worked?