Quotheraven
Programmer
I am trying to write an SSRS expression for a date field (SAMH_DATE) that needs to be updated on or before 1, 5, 8, and 30 days after a person is admitted to a hospital, If the field PAYOR is LIKE "*SAMH*". The date cell should turn red if the field is not updated on or before these checkpoints. The cell should stay green until the next checkpoint if it is updated on time or before. If the field is updated late, the cell should turn green when updated, then red at the next checkpoint and stay red until it is updated. Since it was a late update to the previous checkpoint, it should turn red again at the next checkpoint. There is a DAYS_SINCE_ADMISSION field, a DAYS_SINCE_SAMH_UPDATE field, an ADMIT_DATE field, and a SAMH_DATE field. I have written this so many times and have not been able to get something to work. Any help would be greatly appreciated.