You need to sign in to do that
Don't have an account?
Raghu Raman
Calculate No of Days Between two Status
Hi,
I need to create a report on a custom object and calculate no of days between status.
For example, I need to calculate the number of days between status Approved and Closed. How long it took to Close after Approved ?
Regards,
Raghu
I need to create a report on a custom object and calculate no of days between status.
For example, I need to calculate the number of days between status Approved and Closed. How long it took to Close after Approved ?
Regards,
Raghu
A dirty way to do it is, have 2 custom fields of data type date. When status is approved, copy the date last modified to the 1st cusotm field and when status is closed, copy the date last modified to 2nd custom field. Then do a delta between these 2 fields to derive your number of days which can go in to your 3rd custom field. If you want to get down to a level of hours then make your data types to date time instead of date.