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.

