function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Laura Dix-BowlerLaura Dix-Bowler 

Difference of two hours in Date/Time field and Time field

I'm getting a difference of 2 hours in two fields on my lead:
Created Time13:46  
Created Date.Time09/10/2017 15:46

Created Time is populated by a workflow rule on lead creation: 
Formula Value:
TIMEVALUE( Created_Date_Time__c )

The field Created_Date_Time__c is a formula field Date/Time.
Formula value:
CreatedDate

Any ideas what is going on?
Best Answer chosen by Laura Dix-Bowler
Alain CabonAlain Cabon
Paris and Johannesburg have the same timezone ( GMT +02:00 )

test formula1 : TIMEVALUE(  test_datetime__c  ) => GMT = local time - 2 hours.

Regards

All Answers

Alain CabonAlain Cabon
Hello,

Lightning Experience, Quick Actions, and the Salesforce1 mobile browser app: A time field displays GMT, always.

https://help.salesforce.com/articleView?id=custom_field_time_overview.htm

User-added image

User-added image


User-added image

Paris 

 
Alain CabonAlain Cabon
Paris and Johannesburg have the same timezone ( GMT +02:00 )

test formula1 : TIMEVALUE(  test_datetime__c  ) => GMT = local time - 2 hours.

Regards
This was selected as the best answer
Laura Dix-BowlerLaura Dix-Bowler
Thanks Alain!