you might need to clarify this a little more.
my guess is that the episode.last_date_of_service is a field that is updated on each service entry so it is always the most recent date so it is not really indicating if a service was delivered prior to it.
Is that correct?
if the field is really the first date of service since admission you likely need to deal with NULL values too.
then it would be something like
(isnull({episode.last_date_of_service}) and
datediff('d',{episode.admission_dte},currentdate})>90)
or
(NOT(isnull({episode.last_date_of_service})) and
datediff('d',{episode.admission_dte},{episode.last_date_of_service})>90)
IP Logged
