Hi, I have this expression but it is returning rows which happened before the 01/12/2021.
AND([Date of complaint]>=DATE(01/12/2021),[Date of complaint]<=Today())
How can I fix this?
I don't see anything wrong with the logic, but the sintax. I always use " " in dates and there is no need to put DATE(01/12/2021). Only: "01/12/2021"
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |