Insert a datetime token value into a date field?

Anonymous
Not applicable

Insert a datetime token value into a date field?

I just made a campaign with one flow step:
Change Data Value 
Attribute: (a date field)
New Value: {{lead.Last Interesting Moment Date}}

However, when I run it, I get an error that there is an invalid token. Apparently {{lead.Last Interesting Moment Date}} is a datetime field and Marketo doesn't want to insert that into a date field. (This is hard to see... I only get that error message sporadically on hover over the token).

Is there way I can insert the date of the Last Interesting Moment into this date field?

Thanks!
Tags (1)
3 REPLIES 3
Josh_Hill13
Level 10 - Champion Alumni

Re: Insert a datetime token value into a date field?

Can you change the type of the field in Admin>field management ? Be careful though if SFDC controls that field.
Anonymous
Not applicable

Re: Insert a datetime token value into a date field?

I can't really change the format of either field. (I'm running into this in a couple of other data pairs I'm referencing.)

The date fields are synced with SFDC and can't be changed without creating major issues all over.

The datetime fields are Marketo system fields and can't be changed.

I think I could make a formula field that converts a datetime to a date... but I don't think I'll then be able to reference that as a token in a smart campaign, so there's no point.


Anonymous
Not applicable

Re: Insert a datetime token value into a date field?

I assume the lack of response to this post means there is no way to do this out of the box without changing the underlying datatype of the field (in our case is coming from MIcrosoft CRM) or writing code outside of Marketo. This is annoying since converting a DateTime into a Date is a very unambiguous operation. This seems like an artificial limitation. Even if we simply had a function library we could use inside of the curly brackets/token syntax we could get by.