Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Filter based on prefixed month in date month

ShantanuDagar
8 - Asteroid

Hey all,

 

I need to separate data into 2, 1 which have addresses with a prefixed date for current month and the 2nd with everything other

 

Data sample would be something like:

*11/02 ABC hhj-1-jhk

*11/02 BCJ 1gh-hhjku

*11/03 ANC 678-ssghhjs

*13/02 ABJ ghjjkj

*13/03 BCH hhhj-gghsa_sas

 

If I run the flow on any date in February, values out of True in filter must be the data in 1,2,4 as they have february (02).

If I run the flow on any date in march, values out of True in filter must be the data in 3 and 5 as they have March (03).

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@ShantanuDagar 
There is a Function DateTimeNow can get the date of running the work flow.

0310-ShantanuDagar.PNG

Labels
Top Solution Authors