contact custom data date field not working in scheduled reminder
When we use the contact custom date field in scheduled reminder condition, then it is not working as expected
CRM_Core_BAO_ActionSchedule::prepareMailingQuery function adding Inner join with contact id and custom value table ID field
Eg :-
SELECT reminder.id as reminderID, reminder.contact_id as contactID, reminder.entity_table as entityTable, reminder., e.id AS entityID, e.id as entityID, e. FROM civicrm_action_log reminder INNER JOIN civicrm_contact e ON e.id = reminder.entity_id WHERE (reminder.action_schedule_id = 22) AND (reminder.action_date_time IS NULL)