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
------------------------------