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.
Solved! Go to Solution.
Can you please share sample input and output expected please.
Will be easy to derive the solution.
Many thanks
Shanker V