Hi Alteryx Team, How do I exclude the previous months and years to my current date Eg today's date is 28-01-2020 It will take all days that are January 2020 and future and exclude December 2019 and further down automatically This is my input table DateName28-01-2020Car06-01-2020Bus 05-12-2019Bike05-12-2022Plane05-02-2017Auto It will read current date - 28-01-2019 My output should be as such - DateName28-01-2020Car06-01-2020Bus05-12-2022Plane

Alteryx date filter

Hi Alteryx Team,

How do I exclude the previous months and years to my current date

Eg today's date is 28-01-2020

It will take all days that are January 2020 and future and exclude December 2019 and further down automatically

This is my input table

Date	Name
28-01-2020	Car
06-01-2020	Bus
05-12-2019	Bike
05-12-2022	Plane
05-02-2017	Auto

It will read current date - 28-01-2019

My output should be as such -

Date	Name
28-01-2020	Car
06-01-2020	Bus
05-12-2022	Plane

Workflow

Help

Accepted answers

OllieClarke

Hi @henrygeorge you can use the following filter

Hope that helps,

Ollie

date filter.yxmd

All comments

afv2688

Hello @henrygeorge,

You could use the following formula on a filter tool to get only the actual data and from the previous month:

REGEX_Replace([Date], '(\d+)\-(\d+)\-(\d+)', '$3\-$2') = Datetimeformat(datetimenow(), '%Y-%m') OR
REGEX_Replace([Date], '(\d+)\-(\d+)\-(\d+)', '$3\-$2') = Datetimeformat(datetimeadd(datetimenow(),-1, 'months'), '%Y-%m')

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

RWvanLeeuwen

Hi @henrygeorge

See the attached workflow that uses the first day of the current month as a dynamic filter

custom dynamic date filter.jpg

Best,

Roland

Infotopics - Benelux partner of the year

Empowering business through analytics. See, Understand, Act!

20200128 custome date filtering dynamic - RWvL.yxmd

OllieClarke

Hi @henrygeorge you can use the following filter

Hope that helps,

Ollie

date filter.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703