I'd like to use RULES to send an email to folks who sign up for an event. I'd like to include a cancellation date in the email that is one week prior to the event date.
What is the best way to calculate that date and insert it in my rules email.
I have to ideas, but don't know how to make either work:
1) Include a hidden field in the content type of type "cancellation date" which is automatically populated with a date one week prior to the event.
2) Include a custom date token in the rules email, something like: [event:field-course-date:value:custom:j - 1 week] (doesn't work). :-(
Looking for ideas on how to make either of these ideas work - or a better approach?
Thanks in advance....