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
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
4 years ago
I don't think you need to list off every possible situation in the formula.  The way I did it,  if the date is between the other two, or if one or both fields are null it will be 'true' (checked),  otherwise it's 'false' (not checked).    


------------------------------
Jeff Peterson
------------------------------
MikeTamoush's avatar
MikeTamoush
Qrew Commander
4 years ago
Jeff,

I understood her ask differently. We interpret this scenario differently.

Sunday Date > Departure date and Arrival Date is null.

In my rule, that is false, in yours, that is true. I am unclear what she is asking for. Her last statement says Sunday date can't be outside of the other dates so I am a bit confused on the specific ask.

------------------------------
Mike Tamoush
------------------------------