Help with Date Expression

AppSheet AppSheet Q&A
1

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?

2

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”

1 Like