I am using Civicoops Rules extension. In our boarding process I need to create a rule to create actions for contacts which are still in a certain group after 14 days. My idea was to use the daily trigger for groups and add a condition for the field created_date. How can I do this?
- Should I use SQL as the compare value e.g. DATE_ADD(CURRENT_TIMESTAMP, INTERVAL 14 day)
- Should I use PHP as the compare value e.g. strtotime('-14 days');
- Should I create a custom condition as explained here