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