Hi All,
can you please help me with below task:
1. Filter out trades with Code equal to 2 - I don't know how to do NOT EQUAL 2 formula
2. Filter out trades with XXX Date within one month or older than 12 months from YYY Date
Much appreciate!
Can you provide some sample data?
YYY Date XXX Date
31/07/2018 11/08/2019
31/07/2018 02/11/2018
31/07/2018 24/07/2019
31/07/2018 09/12/2019
Hi @joanq,
I am not sure if I understand your requierment perfectly but I have created a filter for code -2 and for the date range in 12 months from one of the columns.
The filter for the code should be equal to:
[Code] != -2
The workflow:
The output:
Thanks, nr 1 is done.
For the 2 - I need to filter out dates which have XXX Date within one month from today I guess.
And also filter out XXX dates which are older than 12 months from YYY date - so I am not sure if your workflow answers my question. Sorry I might not described it well.