Equation for find the difference between two dates using saved search.

The below mentioned formula can use to find the difference between two dates in saved search

ABS(NVL(TO_DATE({lastmodifieddate})-TO_DATE({custbody_jj_date_modified}),0))

{lastmodifieddate} - last modified date in the record

{custbody_jj_date_modified} - custom field is used for storing the date. The custom field format is date/time . 

Leave a comment

Your email address will not be published. Required fields are marked *