SOLVED

Populate a date field with a future date

Go to solution
Anonymous
Not applicable

Populate a date field with a future date

We’re trying to create leads with a date field that indicates when the remarketing nurture will start. We’re giving the SDRs 30 days to qualify the lead, but want them to be able to edit this date for individual leads if the process is taking longer.

So, we want the field to initially be populated with Create Date + 30 days (or put differently, Today + 30). Salesforce does that easily using a formula, but the SDRs can’t edit a formula field.

Anyone know of a way to do this in Marketo? We've thought of using different triggers for the nurture, but they all require too much effort from the SDRs - keeping their process as seamless as possible would be so lovely.

Thanks!

We’re trying to create leads with a date field that indicates when the remarketing nurture will start. We’re giving the SDRs 30 days to qualify the lead, but want them to be able to edit this date for individual leads if the process is taking longer. So, we want the field to initially be populated with Create Date + 30 days. Salesforce does that easily using a formula, but the SDRs can’t edit a formula field.

Anyone know of a way to do this in Marketo? We’re trying to create leads with a date field that indicates when the remarketing nurture will start. We’re giving the SDRs 30 days to qualify the lead, but want them to be able to edit this date for individual leads if the process is taking longer. So, we want the field to initially be populated with Create Date + 30 days. Salesforce does that easily using a formula, but the SDRs can’t edit a formula field.Anyone know of a way to do this in Marketo? We’re trying to create leads with a date field that indicates when the remarketing nurture will start. We’re giving the SDRs 30 days to qualify the lead, but want them to be able to edit this date for individual leads if the process is taking longer. So, we want the field to initially be populated with Create Date + 30 days. Salesforce does that easily using a formula, but the SDRs can’t edit a formula field.Anyone know of a way to do this in Marketo?

1 ACCEPTED SOLUTION

Accepted Solutions
Casey_Grimes
Level 10

Re: Populate a date field with a future date

Actually, this can be done in Marketo pretty simply: have a Smart Campaign run upon lead creation (or batch it nightly, what have you) and in your flow step, do a Change Data Value to set the SDR date to {{system.date}} + 30 days. You can technically do this with the actual created date as well, but it's important to note that your Marketo created date may not be the same as your Salesforce created date, and both of those fields are stored as datetime rather than just date.

View solution in original post

8 REPLIES 8
Grégoire_Miche2
Level 10

Re: Populate a date field with a future date

Hi Camille,

Cannot be done in Marketo. In Marketo, you can check a date was 30 days ago. So you could set the field date to today (using the {{system.date}} token as a new value) and filter for every lead for which the field has a value equals to 30 days ago.

Usually, we do this in SFDC using workflows instead of formulas, so that the fields remain editable.

-Greg

Casey_Grimes
Level 10

Re: Populate a date field with a future date

Actually, this can be done in Marketo pretty simply: have a Smart Campaign run upon lead creation (or batch it nightly, what have you) and in your flow step, do a Change Data Value to set the SDR date to {{system.date}} + 30 days. You can technically do this with the actual created date as well, but it's important to note that your Marketo created date may not be the same as your Salesforce created date, and both of those fields are stored as datetime rather than just date.

Grégoire_Miche2
Level 10

Re: Populate a date field with a future date

HI Courtney,

Thx, learnt something today.

-Greg

Anonymous
Not applicable

Re: Populate a date field with a future date

This is awesome, thanks!!!

Brian_Law_-_Dem
Level 2

Re: Populate a date field with a future date

Very cool solution. Thanks!

Phillip_Wild
Level 10

Re: Populate a date field with a future date

Hi Courtney

Under which conditions can you sum up tokens and dates? I haven't seen "adding" functionality before outside of some beta stuff.

Thanks, Phil

Casey_Grimes
Level 10

Re: Populate a date field with a future date

Hi Philip,

Both date and datetime conditions can be altered so long as you have another established date field to run the "adding" with (i.e., something in a token.) They take whatever values your date/datetime constraint fields will (i.e., minutes, hours, days, etc.)

John_Bogdanski3
Level 3

Re: Populate a date field with a future date

Big help for me. Thank you!