I need a second set of eyes on an expression. I have created a virtual column that is a Yes/No column designed to tell me if the patient’s most recent discharge is older than 14 days but not over 30 days yet. The expression feeds a format rule that checks the virtual column for a a TRUE value.
The expression for the virtual column is
AND(
DATE([Latest Discharge Date])<Date(TODAY()-14),
DATE([Latest Discharge Date])>Date(TODAY()-30)
)
Today’s date is July 13. I am noticing that patients with a most recent discharge date of June 13 are not getting flagged for this. I have another filter that colors patients whose most recent discharge date is older than 30 days. That one seems to be working fine, and for the most part the expression above seems to be working, but i suspect tomorrow, the same issue will apply to people who were discharged on June 14.
Seems simple math, but the greater than, less than part is throwing me, i think.
What am i missing?