Forum Discussion

TaraStroup's avatar
TaraStroup
Qrew Member
4 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
SSNJeffP's avatar
SSNJeffP
Qrew Captain
4 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's avatar
JimHarrison
Qrew Champion
12 months ago
 
I added the <= and now that doesn't cause an error.