DateTimeDiff not giving desired result

[ShantanuDagar]

Hey,

I am using datetimediff to filter out some data.

Question: If Column A = XYZ, Field (sign off date) must not be blank or older than 12 months for the data.

I have to identify data which does not fulfill this, so if column A = XYZ, (sign off date) field must be blank or older than 12 months 

I am using this as filter.

[Column A]="XYZ" AND (IsEmpty([sign-off date]) OR DateTimeDiff([sign-off date],DateTimeNow(),'months') > 12)

sign-off date is in "date" data type and (Mar 15, 2022 12:00:00 AM) in this format.

There are multiple data records which should come out of T filter but getting 0 records.

[ShankerV]

@ShantanuDagar 

Can you please share sample input and output expected please.

Will be easy to derive the solution.

Many thanks

Shanker V

[KrishnaChithrathil · Accepted solution]

@ShantanuDagar 

Are you looking for this?

Input:

[binuacs]

@ShantanuDagar One way of doing this