Re: Can I calculate the "days between" two different date fields in a custom field?

Anonymous
Not applicable

Can I calculate the "days between" two different date fields in a custom field?

We have a date that a lead enters one of our steps and the date they enter the next step. We would like to calculate the delta between these days on order to report on the average time a lead spends in each step.

I believe that my best shot is through "Custom Fields" in the Admin tab.

Very similar to the Excel calculation:   =DAYS360(A1,B1,FALSE)
or
=NETWORKDAYS(A1,B1)

Thank you
Tags (1)
1 REPLY 1
Anonymous
Not applicable

Re: Can I calculate the "days between" two different date fields in a custom field?

Makes sense but unfortuanetly no.

Workarounds
- Use SF to make a calculated field. However that field value only syncs back to Marketo when there is a a data changes. Works great in SF, not reliable in Marketo.
- Create another field called something like Stage Age  and make it a Lead Scoring field. Then add a value of +1 every day. I have done this for stage age in the past. Not exact but may do the trick.
- There is a better solution using a web hook. Haven't done it but others in the community might be able to chine in.