Or / and expressions

[FaCe]

Hi,

i'd like to filter only my records that have due date [TODO] = today and the days before today.

This formula works properly:

OR(
[TODO] = TODAY(),
[TODO] < TODAY()
)

Except it shows also the records that have no date value in [TODO]

Than i probably should add:

ISNOTBLANK[TODO]

but how to concatenate it to the formula above ?

I've tried with:

OR(
[TODO] = TODAY(),
[TODO] < TODAY(),
ISNOTBLANK([TODO])
)

But doesn't work ...

[diogolupcosta · Accepted solution]

AND(
ISNOTBLANK([TODO]),
 OR(
  [TODO] = TODAY(),
  [TODO] < TODAY()
 )
)

[FaCe]

Thanks a bunch! It works like a charm ...