I have a field called {Expires}. I would like to use the filterByFormula parameter via the API to retrieve records that have no expiration date or that have not yet expired.
This successfully retrieves records that have no expiration:
{Expires}=’’
This successfully retrieves records that have not yet expired:
IS_BEFORE(TODAY(), {Expires})
Putting the two statements into an “OR” condition seems like it should work, however it only returns records that have not yet expired—omitting records that are empty/blank/have no expiration:
OR({Expires}=’’, IS_BEFORE(TODAY(), {Expires}))
I have also tried testing for ISERROR rather than =’’, but the behavior is the same. This works as expected (returns records with an empty/blank {Expires} field):
ISERROR(IS_BEFORE(TODAY(), {Expires}))
This omits records with empty {Expires}:
OR(ISERROR(IS_BEFORE(TODAY(), {Expires})), IS_BEFORE(TODAY(), {Expires}))