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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.