Loading

DATETIMEVALUE formula returns incorrect user time zone

게시 일자: Oct 13, 2022
상세 설명
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.
솔루션

Unfortunately, we cannot change this behavior.
Knowledge 기사 번호

000386728

 
로드 중
Salesforce Help | Article