Dynamic Filter

[yedunathan1983]

Hi ,

I am relatively new to alteryx

I would like to apply a custom filter where alteryx filters the current year .and ignores all other years 

For example the field contains Year of projected projected billing(2017,2018,2019) etc.I want to keep only current year which is 2017,this field is in the text format 

How can we dynamically give this command in Alteryx

Thanks

Yedu

[Kenda · Accepted solution]

Hello @yedunathan1983. You could add a filter with the following expression: [Year of Projected Billing]=left(DateTimeToday(),4).

[yedunathan1983]

Thanks forh the help , it worked