Loading

DATETIMEVALUE formula returns incorrect user time zone

Julkaisupäivä: Oct 13, 2022
Kuvaus
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.
Ratkaisu

Unfortunately, we cannot change this behavior.
Knowledge-artikkelin numero

000386728

 
Ladataan
Salesforce Help | Article