Filtering with both AND and OR conditions

Hi @RJ_Martino
You can create a formula field to filter on that includes any conditions you want to filter on combined in any way you want.

Let’s say you call this field “Filter Formula”, and give it a formula something like this:

IF(
  AND(
    {Date Arrive},
    OR(
      IS_SAME({Date Arrive}, DATETIME_PARSE('4/30/2020', 'M/D/YYYY')),
      IS_BEFORE({Date Arrive}, DATETIME_PARSE('4/30/2020', 'M/D/YYYY'))
    ),
    OR(
      {Departure Date} = BLANK(),
      OR(
        IS_SAME({Departure Date}, DATETIME_PARSE('4/1/2020', 'M/D/YYYY')),
        IS_AFTER({Departure Date}, DATETIME_PARSE('4/1/2020', 'M/D/YYYY'))
      )
    )
  ),
  TRUE()
)

This will output a 1 in the field when your conditions are met (TRUE() resolves to 1) and will be blank if your conditions are not met. You can make the formula arbitrarily complex.

Then, you can just filter on this field – set the filter where “Filter Formula = 1”.

Hope that helps. (I did not test the formula, so ping back if it throws an error or doesn’t work for some reason)

IF(
  AND(
    {Date Arrive},
    OR(
      IS_SAME({Date Arrive}, DATETIME_PARSE('4/30/2020', 'M/D/YYYY')),
      IS_BEFORE({Date Arrive}, DATETIME_PARSE('4/30/2020', 'M/D/YYYY'))
    ),
    OR(
      {Departure Date} = BLANK(),
      OR(
        IS_SAME({Departure Date}, DATETIME_PARSE('4/1/2020', 'M/D/YYYY')),
        IS_AFTER({Departure Date}, DATETIME_PARSE('4/1/2020', 'M/D/YYYY'))
      )
    )
  ),
  TRUE()
)

The AFTER/BEFORE part could be easier choosing just the previous/next day, isn’t it? :thinking: