Date Based Email Automation with Mailchimp


We are trying to use Mailchimp automated campaigns to send an email 1 year fro the date of a patient’s last appointment. However, the only dates that seem to be coming through from Cliniko/visible to me within Mailchimp are Date of Birth and Latest Appointment Date when the field i really need is Last Appointment Date.

Has anyone else tried this and are they able to assist? I just need to figur eout how to tap into that particular date field.

Gill @ Clinical Physio