Salesforce Calculated the number of Days since last User Login

Adding a custom formula to a Salesforce Report to calculated Days Ago on User Last Login Date

me@jaykilleen.com wrote this about 3 years ago and it was last updated about 3 years ago.


← Back to the Posts

After building a report using the User table. Add a column using a Row-Level Formula.

The formula has a Formula Output Type of Number and the Decimal Points is 0.

The formula is:

TODAY() - DATEVALUE(User.LastLoginDate)

The User.LastLoginDate is wrapped in a DATEVALUE function so that a Date is being subtracted from another Date (rather than a Date less a DateTime).