function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jacqueline PavelyJacqueline Pavely 

create a report that displays the number of days from quote to closed won

Deepali KulshresthaDeepali Kulshrestha
Hi Jacqueline, 


Description    
We can follow the below-mentioned steps if we need to show a Field on the record or a Report with information with Days since "Last Activity".

Resolution    
Create a custom formula field on the object with (Data Type - Formula & Formula Return Type - Number ).
Use the formula: TODAY() - LastActivityDate
Since "LastActivityDate" is a system field it will only be visible when inserting the formula.
This field will calculate based upon the Last Activity field.
Now you can create a Report on the object showing the field for Days since "Last Activity".
​Few points to remember:
Standard objects have the "Last Activity" field by default when you create a report.
Last activity date for the custom object will appear only when you have checked "Allow Activities" checkbox.
Future activities can result in negative numbers being displayed.
When you have Shared Activities for your Contacts, Last Activity will only show for the Primary Contact.
Not all objects support "LastActivityDate" check the API Guide to see if your object does.


I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha