Loading

DATETIMEVALUE formula returns incorrect user time zone

Publiceringsdatum: Oct 13, 2022
Beskrivning
The DATEVALUE formula incorrectly calculates the user time zone in list views, reports, and related lists.

Reason:

This issue happens when:
  • There is a custom field with a formula that accesses a DATETIME field AND
  • You use that custom field in a related list.
The date time data value is in GMT and not time zone sensitive.

For example:

Consider a 'Time Sheet' parent record and 'Time Entry' child record in the related list.

Assuming 'Time Entry' has a DATETIME field called 'Start_Date_Time__c'

Create a custom formula field in the 'Time Entry' object with this 
TEXT( Start_Date_Time__c)
When viewing the time entry record in the related list, the date time shown in the custom formula field is in GMT time zone. It does not take into account the time zone setting of the users.
Lösning

Unfortunately, we cannot change this behavior.
Knowledge-artikelnummer

000386728

 
Laddar
Salesforce Help | Article