SELECT patient.Patient_ID, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, patient.Status, patient.DOB_M0066 FROM #Request.prefix_db_agency#.patient WHERE patient.Agency_ID = #session.AgencyID# AND patient.DOB_M0066 BETWEEN #CreateODBCDate(Today)# AND #CreateODBCDate(Period)# AND patient.Status = 'active' ORDER BY patient.Last_Name_M0040 ASC

Patients birthdays in the next 2 weeks

#PatientLast#, #PatientFirst# - #DOB_M0066#