Script to calculate formula on workflow postfunction.

U Sravani September 25, 2019

Can anyone please help me in writing a script to calculate below formula:

Field A = Custom date field

Field B = Custom date field

Field C = Custom date field

Field D = Custom date field

I need to calculate

Field E(Custom number field) = ((Duration between A,B)-(Duration between C,D))/(Duration between C,D)

1 answer

0 votes
Ravi Sagar _Sparxsys_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 25, 2019

Hi @U Sravani 

There are lot of examples here

You can learn how to deal with dates on this page.

Give it a try and share the code if you need help.

Ravi

Suggest an answer

Log in or Sign up to answer