Multiple Condition If/Then
Good Morning! I have an If/Then Statement that I need to have multiple conditions. I want the find the date between two appointments. Both Appointment dates are listed in the field [appointment date]...
Forum Discussion
I have a parent table of patients with a child table of appointments which is on a one to many relationship. So one patient may have several appointments, with no current limit on number of appointments. Within appointments i do have a field that is reason for appointment as well as one that has the appointment date. From there i am using a numeric formula field to calculate. I hope this helps!
------------------------------
Hunter Collins
------------------------------
------------------------------
Hunter Collins
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHunter
I need to make a summary field on he Parent record for the maximum date of the appointment where the [Reason for Visit] equals NEW PATIENT
Then repeat for US IN MAP
Now you have Two clean fields on the Patient record and you can subtract.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I need to make a summary field on he Parent record for the maximum date of the appointment where the [Reason for Visit] equals NEW PATIENT
Then repeat for US IN MAP
Now you have Two clean fields on the Patient record and you can subtract.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Thank you so much Mark! You are a lifesaver
------------------------------
Hunter Collins
------------------------------