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 DateAmt12/31/2019 0:006011/30/2019 0:0050001/31/2020 0:0024501/31/2020 0:0015003/31/2020 0:00103/31/2020 0:00503/31/2020 0:00253/31/2020 0:00123/31/2020 0:00133/31/2020 0:0014 Output DateAmt3/31/2020 0:00103/31/2020 0:00503/31/2020 0:00253/31/2020 0:00123/31/2020 0:00133/31/2020 0:0014 thank you 🙂

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Date Filter

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