Filter Data - Greater than 4 months

[JDong]

Hi All,

I have a date field with follow format:

Date
2021-04-22 00:00:00

2021-06-22 00:00:00

2021-07-22 00:00:00

2021-08-22 00:00:00

2021-12-22 00:00:00

In my data set I want to filter all records if the month is 4 months greater than current system month.

So since we are in April...data from August should be filtered.

Thanks.

[Aaron_Harter · Accepted solution]

Hi @JDong, 

Try the attached Filter expression:

 

[JDong]

Hi Aaron,

It has also filtered also predated records ?

I see very less records now.

It should from entire dataset filter only those records that are greater than 4 months. 

Thanks

[jeff_reynolds]

Try changing the filter from '='  to '<'

[JDong]

I seeit is not picking the NULL and ' ' date values. @Aaron_Harter  @jeff_reynolds 

How can I fix this ? 

[jeff_reynolds]

Not quite sure what your data actually looks like, but if your data has null / empty values that you want passed through the filter, you could add something like this to the logic:

 

. Now only data that is within the four months OR has no value will go through.