Discussions

Expand all | Collapse all

Formula Date field based on conditions

  • 1.  Formula Date field based on conditions

    Posted 28 days ago
    I have a Formula Date Field Titled "Tentative Discharge Date". I also have a dropdown field titled "Reason for Placement", and a Date field title Placement Date, I want the following to happen with the formula for Tentative Discharge Date

    • If Reason for Placement=Customer had contact with known positive, Tentative Discharge Date is 14 days AFTER Placement Date
    • If Reason for Placement=Customer is showing symptoms,Tentative Discharge Date is 7 days after Placement Date, if there is no value in Date COVID-19 Tests Results Received, otherwise expected discharge date is 7 days after Date COVID-19 Tests Results Received
    • If Reason for Placement=Customer is positive,Tentative Discharge Date is 7 days after Date COVID-19 Tests Results Received
    :-)

    ------------------------------
    Ermias Bean
    ------------------------------


  • 2.  RE: Formula Date field based on conditions

    Posted 26 days ago
    Edited by Mark Shnier (YQC) 26 days ago
    try this

    IF(
    [Reason for Placement] = "Customer had contact with known positive], [Placement Date] + Days(14),
    [Reason for Placement] = "Customer is showing symptoms" and IsNull([Date COVID-19 Tests Results Received]), [Placement Date] + Days(7),
    [Reason for Placement] = "Customer is showing symptoms" and not IsNull([Date COVID-19 Tests Results Received], 
             [Date COVID-19 Tests Results Received] + Days(7),
    [Reason for Placement] = "Customer is positive", [Date COVID-19 Tests Results Received] + Days(7)
    )


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Formula Date field based on conditions

    Posted 10 days ago
    thanks Mark,  I think I need to change the Tentative Discharge Date formula; it should be;

    If the field "Entrance Reason" = New Placement or customer changed room

    • If [Reason for Placement]="Customer had contact with known positive," [Tentative Discharge Date] is  [14] days after [Placement Date]
    • If [Reason for Placement]="Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
      • If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if that is blank, [Tentative Discharge Date] is 10 days after the [Placement Date]
    • If [Reason for Placement]="Customer is positive", Tentative Discharge Date is 10 days after Date of First Symptoms
    If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed or if that is Null, [Tentative Discharge Date] is 10 days after the [Placement Date]

    ------------------------------
    Ermias Bean
    ------------------------------



  • 4.  RE: Formula Date field based on conditions

    Posted 10 days ago
    There seems to be an omission in your description. 
    If the Entrance Reason isn't New Placement or customer changed room AND Date of first Symptoms is NOT NULL - what is the tentative discharge date.
    Also is the are highlighted in orange intended to be dependent on the reason for placement (statement above it).
    If the field "Entrance Reason" = New Placement or customer changed room

    • If [Reason for Placement]="Customer had contact with known positive," [Tentative Discharge Date] is  [14] days after [Placement Date]
    • If [Reason for Placement]="Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
      • If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if that is blank, [Tentative Discharge Date] is 10 days after the [Placement Date]
    • If [Reason for Placement]="Customer is positive", Tentative Discharge Date is 10 days after Date of First Symptoms
    If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed or if that is Null, [Tentative Discharge Date] is 10 days after the [Placement Date]

    Is it possible to create a table with the tentative release date and the conditions which would cause that date, for example:
    14 days after Placement: Customer contact with known positive
    10 days after Placement: Customer showing symptoms and no date of first symptoms and no Covid test date
    10 days after First Symptoms: Customer is Positive
    ...
    Let me know if you can - happy to help..





    ------------------------------
    Neil Schneider
    ------------------------------



  • 5.  RE: Formula Date field based on conditions

    Posted 10 days ago
    I agree with Neil,
    Can you state the rules without the indenting] even if the conditions seem repetitive.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 6.  RE: Formula Date field based on conditions

    Posted 10 days ago
    Sorry the indenting was inadvertent.

    ------------------------------
    Ermias Bean
    ------------------------------



  • 7.  RE: Formula Date field based on conditions

    Posted 9 days ago
    Ermais,
    There is still a problem with the sequence of the logic checks,  please sequence these properly as QuickBase will evaluate the tests in the order they appear.  for example this is the second test, but what if the [Date of First Symptoms] is null?  You see you need to deal with that possibility before you et to the 2nd text.
     

    If [Reason for Placement]="Customer is showing symptoms", [Tentative Discharge Date] is 10 days after[Date of First Symptoms]


    so you will need to check for that first.  If you would like one on one assistance in helping you think though the correct logic steps, contact me by email.
     


    • If [Reason for Placement]="Customer had contact with known positive," [Tentative Discharge Date] is  [14] days after [Placement Date]
    • If [Reason for Placement]="Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
      • If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if that is blank, [Tentative Discharge Date] is 10 days after the [Placement Date]
    • If [Reason for Placement]="Customer is positive", Tentative Discharge Date is 10 days after Date of First Symptoms
    If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed or if that is Null, [Tentative Discharge Date] is 10 days after the [Placement Date]



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 8.  RE: Formula Date field based on conditions

    Posted 9 days ago
    Hi Mark, thanks.

    If [Reason for Placement]="Customer is showing symptoms", [Tentative Discharge Date] is 10 days after[Date of First Symptoms]



    If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if this is Null, [Tentative Discharge Date] is 10 days after the [Placement Date]

    ------------------------------
    Ermias Bean
    ------------------------------



  • 9.  RE: Formula Date field based on conditions

    Posted 9 days ago
    Please sequence you tests in the sequence they need to be done, but testing for those null date situations first and without the indenting.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 10.  RE: Formula Date field based on conditions

    Posted 9 days ago
    Thanks Mark, I will get back with you on this

    ------------------------------
    Ermias Bean
    ------------------------------



  • 11.  RE: Formula Date field based on conditions

     
    Posted 4 days ago
    If the field "Entrance Reason" = New Placement or customer changed room 
    • If [Reason for Placement]="Customer had contact with known positive," [Tentative Discharge Date] is  [14] days after [Placement Date]
    • If [Reason for Placement]="Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms], If [Date of First Symptoms] is Null, Tentative Discharge Date is 10 days after the [Placement Date]
    • If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if that is Null, [Tentative Discharge Date] is 10 days after the [Placement Date]
    • If [Reason for Placement]="Customer is positive", Tentative Discharge Date is 10 days after Date of First Symptoms
    If [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if that is Null, [Tentative Discharge Date] is 10 days after the [Placement Date]

    If Entrance Reason is = to "Customer returned after Pre-clearance departure", then the Tentative discharge date is 10 days after the Date of First Symptoms. 

    Note: The Entrance Reason is required and only includes the options New Placement, Customer Changed Room, and Customer returned after Pre-Clearance departure.


    ------------------------------
    Phelan (DHS) Sanders
    ------------------------------



  • 12.  RE: Formula Date field based on conditions

     
    Posted 4 days ago
    Sorry, posing it in hopefully a better format below

    If Date of First Symptoms is NULL, Tentative Discharge Date is 10 days after Date COVID-19 Test Completed or if that is NULL, Tentative Discharge Date is 10 days after Placement Date


    If [Entrance Reason] = "New Placement" or "Room Change", [Tentative Discharge Date] is;;;
     
    If [Reason for Placement] = "Customer had contact with known positive", [Tentative Discharge Date] = 14 days after [Placement Date]
    If [Reason for Placement] = " Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
    If [Reason for Placement] = "customer is positive", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
    If [Entrance Reason] = "!Customer returned after preclearance departure!", [Tentative Discharge Date] is 10 days after [Placement Date]


    ------------------------------
    Phelan (DHS) Sanders
    ------------------------------



  • 13.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Phelan,
    I just sent you a reply via the discussion groups.  Let me know if you didn't get it..
    Here's the formula (the post had an explanation in it):
    Neil


    var bool newPlacement = [Entrance Reason] = "New Placement";
    var bool changedRoom = [Entrance Reason] = "Customer Changed Room";
    var bool newRoom = $newPlacement OR $changedRoom;
    var bool customerReturned = $newRoom and ([Entrance Reason] = "Customer returned after Pre-Clearance departure");
    var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive");
    var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms");
    var bool customerPostive = $newRoow([Reason for Placement]="Customer is positive");
    var bool noSymptoms = isNull([Date of First Symptoms]);


    var bool noSymptomsDate = isNull([Date of First Symptoms]);
    var date symptomsDate = if ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10)));
    var bool noCovidDate = isNull([Date COVID-19 Test Completed]);
    var date covidDate = if ($noCovidDate, ([Placement Date] + Days(10)), ([Date COVID-19 Test Completed] + Days(10)));

    var bool fourteenDays = [Placement Date] + Days(14);

    if ( $positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,
    $noSymptomsDate, $covidDate,
    $customerPositive, $symptomsDate,
    $noSymptomsDate , $covidDate
    $customerReturned, $symptomsDate)



      Neil Schneider







  • 14.  RE: Formula Date field based on conditions

    Posted 4 days ago
    I just noticed that the no symptoms date occurs twice in my answer.  It follows the logic provided, but isn't logical in the end.  Whichever of the lines highlighted below is incorrect you can just delete. Also there's a missing comma after the second occurance of the noSymptoms sdate..

    if ( $positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,
    $noSymptomsDate, $covidDate,
    $customerPositive, $symptomsDate,
    $noSymptomsDate , $covidDate
    $customerReturned, $symptomsDate)

    ------------------------------
    Neil Schneider
    ------------------------------



  • 15.  RE: Formula Date field based on conditions

     
    Posted 4 days ago
    Here is what is there now;


    var bool newPlacement = [Entrance Reason] = "New Placement";
    var bool changedRoom = [Entrance Reason] = "Customer Changed Room";
    var bool newRoom = $newPlacement or $changedRoom;
    var bool customerReturned = $newRoom and ([Entrance Reason] = "Customer returned after Pre-Clearance departure");
    var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive");
    var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms");
    var bool customerPostive = $newRoom and ([Reason for Placement]="Customer is positive");
    var bool noSymptoms = isNull([Last Date COVID-19 Test Completed]);


    var bool noSymptomsDate = isNull([Date of First Symptoms]);
    var date symptomsDate = if ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10)));
    var bool noCovidDate = isNull([Last Date COVID-19 Test Completed]);
    var date covidDate = if ($noCovidDate, ([Placement Date] + Days(10)), ([Last Date COVID-19 Test Completed] + Days(10)));

    var bool fourteenDays = [Placement Date] + Days(14);  <<<<<<Error expecting bool but found date

    if ( $positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,
    $noSymptomsDate, $covidDate,
    $customerPositive, $symptomsDate,
    $noSymptomsDate , $covidDate
    $customerReturned, $symptomsDate)




    ------------------------------
    Del
    ------------------------------



  • 16.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Duplicates are in red: The second one needs an additional comma added (as it is below).  
    var bool newPlacement = [Entrance Reason] = "New Placement";
    var bool changedRoom = [Entrance Reason] = "Customer Changed Room";
    var bool newRoom = $newPlacement or $changedRoom;
    var bool customerReturned = $newRoom and ([Entrance Reason] = "Customer returned after Pre-Clearance departure");
    var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive");
    var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms");
    var bool customerPostive = $newRoom and ([Reason for Placement]="Customer is positive");
    var bool noSymptoms = isNull([Last Date COVID-19 Test Completed]);


    var bool noSymptomsDate = isNull([Date of First Symptoms]);
    var date symptomsDate = if ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10)));
    var bool noCovidDate = isNull([Last Date COVID-19 Test Completed]);
    var date covidDate = if ($noCovidDate, ([Placement Date] + Days(10)), ([Last Date COVID-19 Test Completed] + Days(10)));

    var bool fourteenDays = [Placement Date] + Days(14);  <<<<<<Error expecting bool but found date

    if ( $positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,
    $noSymptomsDate, $covidDate,
    $customerPositive, $symptomsDate,
    $noSymptomsDate , $covidDate,
    $customerReturned, $symptomsDate)





  • 17.  RE: Formula Date field based on conditions

     
    Posted 4 days ago
    Thank you, Plugging it in now

    ------------------------------
    Del
    ------------------------------



  • 18.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Del,
    Great.  In case you didn't get the second message I just added there's a duplicate line in the resulting part of the formula.  The noSymptoms result is in there twice, and the second occurrence doesn't have a comma after it.  You'll need to delete the one that is incorrect and add a comma..
    Neil



      Neil Schneider







  • 19.  RE: Formula Date field based on conditions

     
    Posted 4 days ago
    Getting an error below


    var bool newPlacement = [Entrance Reason] = "New Placement";
    var bool changedRoom = [Entrance Reason] = "Customer Changed Room";
    var bool newRoom = $newPlacement or $changedRoom;
    var bool customerReturned = $newRoom and ([Entrance Reason] = "Customer returned after Pre-Clearance departure");
    var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive");
    var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms");
    var bool customerPositive = $newRoom and ([Reason for Placement]="Customer is positive");
    var bool noSymptoms = isNull([Last Date COVID-19 Test Completed]);


    var bool noSymptomsDate = isNull([Date of First Symptoms]);
    var date symptomsDate = if ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10)));
    var bool noCovidDate = isNull([Last Date COVID-19 Test Completed]);
    var date covidDate = if ($noCovidDate, ([Placement Date] + Days(10)), ([Last Date COVID-19 Test Completed] + Days(10)));

    var bool fourteenDays = todate([Placement Date] + Days(14),

    If ($positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,  <<<Error expecting bool but found date
    $customerPositive, $symptomsDate,
    $customerReturned, $symptomsDate)

    ------------------------------
    Del
    ------------------------------



  • 20.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Typo on this line:
    var bool fourteenDays = [Placement Date] + Days(14),
    Change the comma (in red) to a semi colon - so this:
    var bool fourteenDays = [Placement Date] + Days(14);
    Please replace that line and try again
    Neil






  • 21.  RE: Formula Date field based on conditions

     
    Posted 4 days ago
    var bool fourteenDays = todate([Placement Date] + Days(14); <Error expecting ")"

    ------------------------------
    Del
    ------------------------------



  • 22.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Missed that - change the line from:
    var bool fourteenDays = ToDate([Placement Date] + Days(14);
    to (add a parenthesis at the end before the semi colon)
    var bool fourteenDays = ToDate([Placement Date] + Days(14));



      Neil Schneider







  • 23.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Del,
    Hang on for a second - I think I see a couple of typos..

    On May 26, 2020, at 11:42 AM, Neil Schneider <neil@team707.com> wrote:

    Missed that - change the line from:
    var bool fourteenDays = ToDate([Placement Date] + Days(14);
    to (add a parenthesis at the end before the semi colon)
    var bool fourteenDays = ToDate([Placement Date] + Days(14));



      Neil Schneider

    <PastedGraphic-13.tiff>

      Neil Schneider







  • 24.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Del,
    In one of my transcriptions I messed up this line...
    var bool fourteenDays = [Placement Date] + Days(14);
    It should be
    var date fourteenDays = [Placement Date] + Days(14);

    fourteenDays is a date, not a boolean.
    Not sure what happened..
    Neil

    On May 26, 2020, at 11:52 AM, Neil Schneider <neil@team707.com> wrote:

    Del,
    Hang on for a second - I think I see a couple of typos..

    On May 26, 2020, at 11:42 AM, Neil Schneider <neil@team707.com> wrote:

    Missed that - change the line from:
    var bool fourteenDays = ToDate([Placement Date] + Days(14);
    to (add a parenthesis at the end before the semi colon)
    var bool fourteenDays = ToDate([Placement Date] + Days(14));



      Neil Schneider

    <PastedGraphic-13.tiff>

      Neil Schneider

    <PastedGraphic-13.tiff>

      Neil Schneider







  • 25.  RE: Formula Date field based on conditions

    Posted 4 days ago
    Del,
    Just checking - any luck with the formula?
    Neil

    On May 26, 2020, at 11:57 AM, Neil Schneider <neil@team707.com> wrote:

    Del,
    In one of my transcriptions I messed up this line...
    var bool fourteenDays = [Placement Date] + Days(14);
    It should be
    var date fourteenDays = [Placement Date] + Days(14);

    fourteenDays is a date, not a boolean.
    Not sure what happened..
    Neil

    On May 26, 2020, at 11:52 AM, Neil Schneider <neil@team707.com> wrote:

    Del,
    Hang on for a second - I think I see a couple of typos..

    On May 26, 2020, at 11:42 AM, Neil Schneider <neil@team707.com> wrote:

    Missed that - change the line from:
    var bool fourteenDays = ToDate([Placement Date] + Days(14);
    to (add a parenthesis at the end before the semi colon)
    var bool fourteenDays = ToDate([Placement Date] + Days(14));



      Neil Schneider

    <PastedGraphic-13.tiff>

      Neil Schneider

    <PastedGraphic-13.tiff>

      Neil Schneider

    <PastedGraphic-13.tiff>


      Neil Schneider







  • 26.  RE: Formula Date field based on conditions

    Posted 3 days ago
    Hi Neil, running some tests today actually.

    I think we need to change the formula to account for the "Initial Placement Date" for the Entrance Reason = Customer returned after preclearance departure

    When Entrance Reason is Customer returned after preclearance departure , the Tentative Discharge Date should be 10 days after the "Initial Placement Date"(Minimum summary date I plugged in)


    ------------------------------
    Ermias Bean
    ------------------------------



  • 27.  RE: Formula Date field based on conditions

    Posted 3 days ago
    And yes this is the same person. QB was acting finicky when I tried to log in

    ------------------------------
    Ermias Bean
    ------------------------------



  • 28.  RE: Formula Date field based on conditions

    Posted 3 days ago
    Ermias,
    I got a message reject on my last send.  If you didn't get it I was asking you to resend the formula as you have it now.  I'm not sure I have a current version..
    Neil


      Neil Schneider







  • 29.  RE: Formula Date field based on conditions

    Posted 3 days ago
    Sure;


    var bool newPlacement = [Entrance Reason] = "New Placement";
    var bool changedRoom = [Entrance Reason] = "Customer changed room";
    var bool newRoom = $newPlacement or $changedRoom;
    var bool customerReturned = $newRoom and ([Entrance Reason] = "Customer returned after preclearance departure");
    var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive");
    var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms");
    var bool customerPositive = $newRoom and ([Reason for Placement]="Customer is positive");
    var bool noSymptoms = IsNull([Last Date COVID-19 Test Completed]);


    var bool noSymptomsDate = IsNull([Date of First Symptoms]);
    var date symptomsDate = If ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10)));
    var bool noCovidDate = IsNull([Last Date COVID-19 Test Completed]);
    var date covidDate = If ($noCovidDate, ([Placement Date] + Days(10)), ([Last Date COVID-19 Test Completed] + Days(10)));

    var date fourteenDays = [Placement Date] + Days(14);

    If ( $positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,
    $noSymptomsDate, $covidDate,
    $customerPositive, $symptomsDate,
    $noSymptomsDate , $covidDate,
    $customerReturned, $symptomsDate)

    ------------------------------
    Ermias Bean
    ------------------------------



  • 30.  RE: Formula Date field based on conditions

    Posted 3 days ago
    This should do it, let me know.


    var bool newPlacement = [Entrance Reason] = "New Placement";
    var bool changedRoom = [Entrance Reason] = "Customer changed room";
    var bool newRoom = $newPlacement or $changedRoom;
    var bool customerReturned = ([Entrance Reason] = "Customer returned after preclearance departure");
    var bool positiveContact = $newRoom and ([Reason for Placement]="Customer had contact with known positive");
    var bool customerSymtomatic = $newRoom and ([Reason for Placement]="Customer is showing symptoms");
    var bool customerPositive = $newRoom and ([Reason for Placement]="Customer is positive");
    var bool noSymptoms = IsNull([Last Date COVID-19 Test Completed]);


    var bool noSymptomsDate = IsNull([Date of First Symptoms]);
    var date symptomsDate = If ($noSymptomsDate, ([Placement Date] + Days(10)), ([Date of First Symptoms] + Days(10)));
    var bool noCovidDate = IsNull([Last Date COVID-19 Test Completed]);
    var date covidDate = If ($noCovidDate, ([Placement Date] + Days(10)), ([Last Date COVID-19 Test Completed] + Days(10)));

    var date fourteenDays = [Placement Date] + Days(14);
    var date tenDaysAfter = [Initial Placement Date] + Days(10);

    If ( $positiveContact,$fourteenDays,
    $customerSymtomatic, $symptomsDate,
    $noSymptomsDate, $covidDate,
    $customerPositive, $symptomsDate,
    $noSymptomsDate , $covidDate,
    $customerReturned, $tenDaysAfter)

      Neil Schneider