Is there a (simple) way to copy a date field to a datetime field | Community
Skip to main content
April 18, 2017
Question

Is there a (simple) way to copy a date field to a datetime field

  • April 18, 2017
  • 2 replies
  • 2438 views

Hi,

I need to copy values from an old date field to a new SFDC custom datetime field. I tried to use a token for the old field value {{lead.MQL date}} and append it with the {{system.time}} token. At first it seemed to work (notice there's no red squiggly line) I was cheering for Marketo being so flexible but then I noticed the campaign skipped this step because the new value was invalid. Way to get my hopes up.

Anyone has an idea how to do this without too much hassle?

Thanks,

Arthur

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
Level 10
April 18, 2017

Interesting question, Arthur!  I tried a few permutations myself and like you found, the Flow choked on non-datetime tokens (regardless of whether there's also the {{system.time}}).  Maybe there's something we've both missed but I know this works in FlowBoost:

Andrea_Lechner
Level 2
April 18, 2017

If you haven't nested this new field in a bunch of lists or campaigns, you can adjust the type in MKTO and then use your tokens.

SanfordWhiteman
Level 10
April 18, 2017

That's a good point, Andrea. If it were a Text field the token type validation wouldn't apply. But I assumed it was already in use.