Greater than Date expression

[Paul_Grindley]

Hello, I am trying to create a very simple expression to filter out records where the date is equal to or greater than a certain date.

[Enrolment_Date] >= 01/01/2019

I’ve tried looking for something similar but can’t find anything. Thanks in advance.

[Steve · Accepted solution]

Raw dates must be quoted:

[Enrolment_Date] >= "01/01/2019"

See also:

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

[Paul_Grindley]

Many thanks Steve. I thought it might be something simple (like me!!)