Adding a custom formula to a Salesforce Report to calculated Days Ago on User Last Login Date
me@jaykilleen.com wrote this about 4 years ago and it was last updated about 4 years ago.
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
).