I'm trying to dynamically filter my data as per below. This workflow need to run (automatically) every month. Would really appreciate if someone can attach a sample workflow.. Thanks.
[Request 2] column = Filter Current Month (Apr) and Last Month (Mar) dates
Then from [Request 1] column = Filter only previous months (Mar and prior - exclude current month dates)
Data Set:
Request 1 | Request 2 |
2019-04-07 | 2019-04-08 |
2019-04-05 | 2019-04-08 |
2019-04-02 | 2019-04-08 |
2019-04-01 | 2019-04-02 |
2019-03-29 | 2019-04-03 |
2019-03-28 | 2019-04-07 |
2019-03-26 | 2019-04-02 |
2019-03-22 | 2019-04-05 |
2019-03-11 | 2019-03-12 |
2019-02-22 | 2019-03-01 |
2019-02-22 | 2019-04-02 |
2019-02-21 | 2019-03-22 |
2019-02-01 | 2019-04-05 |
2019-01-31 | 2019-02-01 |
2019-01-01 | 2019-01-03 |
2018-12-11 | 2019-04-02 |
2018-03-11 | 2019-03-03 |
Desired Output:
Request 1 | Request 2 |
2019-03-28 | 2019-04-07 |
2019-03-26 | 2019-04-02 |
2019-03-29 | 2019-04-03 |
2019-03-22 | 2019-04-05 |
2019-02-21 | 2019-03-22 |
2019-02-22 | 2019-03-01 |
2019-02-01 | 2019-04-05 |
2019-03-11 | 2019-03-12 |
2019-02-22 | 2019-04-02 |
2018-03-11 | 2019-03-03 |
2018-12-11 | 2019-04-02 |
Solved! Go to Solution.
Hi @Muhammad
Filter Tool with this formula:
ToNumber(DateTimeFormat([Request 2], "%y%m"))
>= ToNumber(DateTimeFormat(DateTimeNow(), "%y%m")) - 1 AND
ToNumber(DateTimeFormat([Request 1], "%y%m"))
<= ToNumber(DateTimeFormat(DateTimeNow(), "%y%m")) - 1
Cheers,
You're great! Thank you so much!!!