Forum Discussion

Qrew Member

3 years ago

Checkbox formula with multiple dates to refrence

Hello, I need to have three date fields Sunday date Departure Date Arrival Date I need a checkbox to be true if the Sunday date is within the Arrival and Departure even if Arrival or depar...

Formulas and functions

JeffPeterson1

Qrew Captain

3 years ago

Hi Tara,

Make a formula checkbox field, and assuming these are all 'Date' fields, this formula:

[SundayDate] <= [Departure] and [SundayDate] >= [Arrival]
or
IsNull([Arrival]) or IsNull([Departure])

------------------------------
Jeff Peterson
------------------------------

JimHarrison
Qrew Champion
2 days ago

I added the <= and now that doesn't cause an error.