Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS Expression for certification updates

Status
Not open for further replies.

Quotheraven

Programmer
Jul 6, 2023
1
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top