Aug 19, 2020 at 08:29 PM

C4C: Workflow Rule with formula functions

1052 Views Last edit Aug 24, 2020 at 12:15 PM 3 rev

Dear SAP team,

We have created into sales quote scenario two extension fields witch help us to monitor when an internal process start and finish, this are date/time type fields. What we need is the difference in days between this two dates, witch would result in a numeric value.

We tried using the field update workflow rule type by trying to establish a formula but the syntax error always show up

Field to be updated, quantity type
Start time field, date/time type
End time field, date/time type

We already tried with "Duration" and "Now" functions but they weren´t useful for our case because the result of both functions is a "date" and what we need is the difference in days between two dates, witch would result in a numeric value.

Does anyone know if this is possible to achieve and what's the correct function or syntax needed?

I´ll look forward for any useful information.

Thanks in advance for your help and best regards,