Comparing 2 dates if 0-7 days diffrence

[system]

Hi the problem am having is that I have 2 queries that am merging on Person ID - One as a Contact Date and the Other as a Discharge Date.

The problem am having is that each person can have multiple contacts on each query so what I want is:
“If the Discharge Date is 0-7 days before Contact Date than use that Discharge Date otherwise leave blank.”

Any ideas?

---

mlgj64 (BOB member since 2018-05-02)

[MarkP]

=DaysBetween([Contact Date];[Discharge Date]) is probably what you’d need to look at.