Quote from skigeek on July 14, 2025, 1:47 pm

I have a list, with a column named: EndDate it has a value or 12/12/2024.  It is configured as  a date and time with the parameters of date only, and standard.

I was trying to create a Crow Canyon View, with a query that will return all records less than today. I configured the view as follows: (look at attached file.) The trip status works by its self but when I add the enddate it returns nothing. I have tried multipe formats [Today], {Today}. {Now}.. Nothing works. Please advise.