Free Trial

Alteryx Designer Desktop Discussions

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

Date Filter

DiyaR
8 - Asteroid

Hi, I have a dataset that I need to filter by last month reported from the fiscal year data. Any suggestions please how to go about achieving this, thanks.

 

Input  
Date Amt
12/31/2019 0:00 60
11/30/2019 0:00 5000
1/31/2020 0:00 2450
1/31/2020 0:00 1500
3/31/2020 0:00 10
3/31/2020 0:00 50
3/31/2020 0:00 25
3/31/2020 0:00 12
3/31/2020 0:00 13
3/31/2020 0:00 14

 

Output  
Date Amt
3/31/2020 0:00 10
3/31/2020 0:00 50
3/31/2020 0:00 25
3/31/2020 0:00 12
3/31/2020 0:00 13
3/31/2020 0:00 14

 

thank you 🙂

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

Something like this?

 

DavidP_0-1588109591111.png

 

DiyaR
8 - Asteroid

thanks Dave P.. that's exactly i was looking for. Now i know where i was failing, i.e. Parse.. 

 

Much appreciated, Thank you 🙂 

DavidP
17 - Castor
17 - Castor

You're welcome.

Labels
Top Solution Authors