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 🙂
Solved! Go to Solution.
thanks Dave P.. that's exactly i was looking for. Now i know where i was failing, i.e. Parse..
Much appreciated, Thank you 🙂
You're welcome.