AND ( (F177 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) OR (F178 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) ) group by F177 order by F177 ---> SELECT count(distinct(p.patient_ID)) as patientvisits, pAdmit.M0030_START_CARE_DT as visit_date FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_agency#. pPatients p ON pAdmit.Patient_ID = p.Patient_ID JOIN #Request.prefix_db_agency#.pAssessments pass ON pass.Admit_ID = pAdmit.Admit_ID AND pass.Status = 0 WHERE p.Status IN (0,1,4) AND pAdmit.Status = 0 AND pAdmit.M0030_START_CARE_DT <= #CreateODBCDate(Form.From_Date)# AND pass.F178 >= #CreateODBCDate(Form.To_Date)# AND LEFT(pass.F26,1) IN (1,4) group by M0030_START_CARE_DT order by M0030_START_CARE_DT

Average Daily Census

Payer Type:

#Replace(Form.PayerType, ",", ", ", "ALL")#

START CARE Date	Patients
#dateformat(visit_date,"mm/dd/yyyy")#	#GetVisitsList.patientvisits#

Average Daily Visits: #numberformat(Avg_Patients,"9.9")# patient visits / day
for the period of #Form.From_Date# to #Form.To_Date# (#totalpatientvisits# visits over #diff# days)