Records between Monday and Friday

[records333]

Goal:

Identify patients that have upcoming appointments Monday through Friday from rundate (on Thursday).

I used a dateadd formula {PAT_ENC.APPT_TIME} in dateadd('d',8,CurrentDate)to CurrentDate to capture appointments within the week of runtime. But user would like a list of appointments hardcoded to capture patients with appointments Monday through Friday from rundate. Is there another date function that should be considered? If so, please provide an example. Thanks in advance.

 

[pmax9999]

The DateAdd function is not necessary for adding days. Try:

{PAT_ENC.APPT_TIME} in [(CurrentDate + 4) to (CurrentDate + 8)]

When run on a Thursday, it will return records where the {PAT_ENC.APPT_TIME} is in the following Monday to Friday.

Hope this helps.

Cheers
Pete

 

[records333]

Sorry for delay in response. It worked! Thanks a mill!