I have a custom object based on the record Created time, I am trying to derive a formula to check whether it's in AM or PM time zone. But due to some UTC conversion issues I am getting a different time in formula.
The formula :
IF( (VALUE(RIGHT(LEFT(TEXT(Call_Datetime_vod__c) , 13),2)) > 12.00) , 'PM', 'AM')
Suppose, 2015-03-17T09:46:41.000Z is my datetime value in system field, I am getting 08 as hour value in my formula field and hence the calculation is getting wrong when the system field's hour is 13 I am getting it as 12.