Date Time formulas

[joanq]

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!

[Qiu]

@joanq 

Can you provide some sample data?

[joanq]

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

[Emil_Kos]

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:

[Emil_Kos]

Hi @joanq,

I have prepared a solution based on your data.

[joanq]

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.

[Emil_Kos]

Hi @joanq,

Please take a look if this helps:

[Emil_Kos]

Hi @joanq,

Does this solution work for you?