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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.