Tips & Tricks: Displaying the full DateTime MM/DD/YYYY AM/PM value in Reports
For some reason (I dunno why) when you add a Standard DateTime field, like Created Date, LastModified Date, Last Stage Change Date to a Report, the Report results only display the MM/DD/YYYY, not the Time (Custom Fields display the full DateTime value fine)
But sometimes users REALLY wanna see the Time a record was Created, or Updated, cuz that $hit's kinda important when you're looking at Case Workloads, or exactly when all the Open Opportunity suddenly got updated by some Process or User gone rogue.
But you don't want to create a new Custom Formula Field just to show the full DateTime value in a Report (because why should you?)
So here's what you can do:
- Create a Row-Level Report Formula
- Select DateTime as the Result
- Insert your DateTime field into the Formula
Of course having standard Salesforce Reports just display the full DateTime MM/DD/YYYY HH:MM AM/PM value would be nice too.
PS. In the case of (bad pun alert) Case: CreatedDate, Last Modified Date, or any Standard DateTime field that you use often in Reports, it might be worth it to bite the bullet and create a dedicated custom Formula(DateTime) field. Because you only get 1 Row-Level Formula per Report, and those are a precious commodity.
But honestly, we (Admins) should not
have to do that, this should be baked into Salesforce Report Types from top to bottom
