Marketo Custom Object data as token in flow step

It sounds as if you may need to enlist some Velocity scripting​.

Another alternative would be to create a smart list where the criteria is YourDateField as a filter with the operator "in time frame" = "This Month", and then run a campaign against this list.

Unfortunately the Smart List date field options don't allow enough flexibility in my view to prescribe the 45 days you are looking for.

Hi, did you ever figure out how to do this? We were trying to do a similar thing by sending an email using the "send alert" flow step but the value of that field lives on the opportunity in Salesforce.While we decided to make that field available in Marketo, we still cannot get the email to send using a token. Any advice or suggestions you have would be great, thanks!

Couldn't you just run a smart campaign on a daily basis that uses criteria from the data object itself to determine whether they're within 45 days of the expiration date and include them in the mailing?

Assuming there's an expiration date field for each record in the object, you could use "between" {{program token that calculates system date plus forty five days}} and {{system date}}. Then, knowing only those who have contracts expiring within forty-five days are included, use a velocity script to list only the contracts that qualify in the body of the e-mail.

The only hang-up, I think, might be that they may receive that e-mail too frequently when they have expiring contracts, so you could apply another criteria, "not was sent e-mail", and include the e-mail that the smart campaign would send. (And set that "not was sent e-mail" for dimension to "last seven days".)

Downside, if you want to give them the full 45 days under all circumstances, you might have to bump it to 52 days to account for the overlap. (53?)