Loading

Include Date/Time Value for Last Modified Date or Created Date in Salesforce Reports

Veröffentlichungsdatum: Jun 24, 2026
Beschreibung

In Salesforce Reports, the Last Modified Date and Created Date fields may display only the date portion despite being configured as date/time fields. This occurs because some reports display only the date value for these fields.
This article explains how to create a formula field of type Date/Time to expose the full date and time value in your Salesforce reports.

Lösung

The workaround is to create a formula field of type Date/Time on the field that is only displaying the date value.

Create a Date/Time Formula Field in Lightning

Follow these steps to create a new formula field in Salesforce Lightning:

  1. Navigate to Setup | Object Manager.
  2. Select the desired object (for example, the Opportunity object).
  3. Select Fields & Relationships and click New to create a new field.
  4. Select the Data Type Formula and click Next.
  5. Name your new field, select the Formula Return Type as Date/Time, and click Next.
  6. In the formula editor, click Insert Field and locate the desired field such as Created Date or Last Modified Date, then click Insert. (Screenshot: The Insert Field dialog in the formula editor with Created Date selected.)Screenshot 2024-09-06 at 9.48.53 AM.png
  7. Finish creating the field — add a Description and Help Text, then click Next.
  8. Assign the desired field-level security and click Next.
  9. Click Save.
  10. Create a new report or edit your existing report to add this new formula field.
  11. If necessary, add the new field to the layouts of any custom report types.
         
Nummer des Knowledge-Artikels

000385683

 
Laden
Salesforce Help | Article