I want to show records where a date-field is either blank or date is more than today

Get Help
1

OpenAI suggested this:
OR([ExpectedDeliveryDate] IS NULL, [ExpectedDeliveryDate] > CURRENT_DATE())
image

I also tried this:
image

This works, but I need to consider NULL:
image

So the question is ;
Why does this not work and what should I use instead?
OR([ExpectedDeliveryDate] IS NULL, [ExpectedDeliveryDate] > CURRENT_DATE())

2

Have a look at List of expressions and Custom expressions, it will help you grasp the concept of Custom Expressions