Change Data Value = Date + X Days | Community
Skip to main content
J
JDNelson1
Community Manager
April 25, 2015
Solved

Change Data Value = Date + X Days

  • April 25, 2015
  • 4 replies
  • 6374 views
I have a date field that I need to populate to be 30 days from the triggered campaign start date.  I was hoping I could do a Change Data Value flow utilizing the {{system.date}} +30 or something, but can't figure out if A) this is allowed, or B) what the proper verbiage to use is - ?  Any assistance?
    Best answer by

    Hi JD,

    It's been a couple of months, so I'm sure you found a way by now, but it is possible to do this in Marketo.

    The syntax is like this: {{system.date}} + 30 days.

    This is a screenshot from a similar use we have in our instance:

    I've yet to see where this is documented, but we've been using it for a while without issue in our Change Data Value flow steps.

    I have a blog post on how this is done as well as some other Marketo date math use cases.

    -Bill

    Bill Lundy

    Digital Pi

    4 replies

    A
    Anonymous
    Accepted solution
    July 20, 2015

    Hi JD,

    It's been a couple of months, so I'm sure you found a way by now, but it is possible to do this in Marketo.

    The syntax is like this: {{system.date}} + 30 days.

    This is a screenshot from a similar use we have in our instance:

    I've yet to see where this is documented, but we've been using it for a while without issue in our Change Data Value flow steps.

    I have a blog post on how this is done as well as some other Marketo date math use cases.

    -Bill

    Bill Lundy

    Digital Pi

      J
      JDNelson1Author
      Community Manager
      July 20, 2015

      bafflingly easy...?!  Thanks!

      J
      JDNelson1Author
      Community Manager
      April 27, 2015
      Yah - I'm hoping to populate a token that says "In 30 days, on {{token}}, you will ..." so I primarily (and only, for that matter) need it to populate the text... I'll look into the SFDC stamp and report back with my findings...  Thanks
      Justin_Norris1
      Justin_Norris1
      New Participant
      April 27, 2015
      I am assuming Josh means to do a wait step with token to "Wait' for system.date + 30 then do a date stamp of your date field. 

      This will work but the drawback is you need to wait out the 30 days for the field to be populated. This could be a problem if you need to access that date field immediately (before the 30 days is up) in order to trigger some other logic. 

      This is drawback of Marketo currently -- there is no ability to do math of that kind. 

      For those scenarios I have typically done the logic in SFDC using a workflow rule or something similar to stamp the field. Then the value syncs back to Marketo and can be used there as well. 

      Make sure to allow time in your flow for the round-trip if you are building immediate next steps based on the date field. 

      Justin Norris | Perkuto
      Josh_Hill13
      Josh_Hill13
      New Participant
      April 27, 2015
      see wait step, Token to see how that works.

      Also
      Wait 30 days works too.
      Terms & ConditionsAccessibility statement

      Loading footer...