The field is a date field. When I entered the token in the wait step I typed it, as I considered that pasting was the reason it didn't work.
Do any of you have an idea for a work around, to tackle this issue? How can I have an e-mail sent 18 months after they passed the test for certificaition, informing our contacts that they have 6 months to renew it. Using the date field mentioned above?
You are on the right track. To Cathal's point, is this a batch or trigger campaign? Also, I have noticed that Mkto can get fickle and if you don't select the token from the drop down, the system will think that the token does not exist, thus creating an error.
One suggestion would be to create an expiration date field and use that minus 6 months for your wait step and see if the system is more agreeable to that.
Another suggestion would be to change 732 days to 18 months. Maybe the number of days is causing an issue.
To answer your questions, at the moment I try to make it a batch campaign which runs daily at 9 AM in the morning. Reason being that I don't really see how to use a trigger in this case, as I want to use a date field (lead.bePART Sales Certificate Acquired_) which contains the exact date when a person passed the exam. Also, I am using data going back to 2011, when were not yet using Marketo + each value is different (people did not pass the exam on the same date).
Concerning your suggestion, what would be the best way to go at it, as it would mean creating another field in the database just for this purpose?
Also it seems that you can only add a value in number of days, see below:
To answer your question Jeff, it is a field that is updated manually.
I've did some tests using a data change trigger, adding a certain amount of days (tested it with 732 days) and it seems to work, which is very positive. Only thing I need to do is an export of allt he data and re-upload it so that the campaign is triggered.
Don't really know why batch campaigns are prohibited from the 'date token'?
Thank you all for helping me think about this one.
Warm regards and already wishing you a joyful holiday season.