I need to Sort/Group By Two Different Date Fields
I have two date fields in a form for potential/admitted patients ? ?Inquiry Date? and ?Admission Date.? Every form has an Inquiry Date but there might not be an Admission Date. I would like to create a bar chart showing how many inquiries and admissions I have had per month. I have already created formulas to count the number of each date (EX: COUNT([Inquiry Date])). These Count Formulas work well as they show the information I want but, my problem is that a patient can inquiry in one month and be admitted the next. How do I sort/group by a date when there are two dates to consider? Any suggestions would be great. Thank you!
EX: Patient?s Inquiry Date is July 30, but Admission Date is Aug 1. When I sort by either date field and group by Month. The patient is either assigned to July as an inquiry or to August as an admission. How can I count the patient as an July inquiry AND an August admission?
EX: Patient?s Inquiry Date is July 30, but Admission Date is Aug 1. When I sort by either date field and group by Month. The patient is either assigned to July as an inquiry or to August as an admission. How can I count the patient as an July inquiry AND an August admission?
