[SalesForce] Timezone issue with Datetime field in salesforce

I have a custom field of type datetime on a custom object. I want to show this field as it is regardless of timezone. As of now, salesforce converts value to user's current timezone while showing on VF page or on standard salesforce pages. Is there any way to avoid that?

Suppose that I am in T1 timezone and I create a record in which datetime field value is 3/10/2013 8:30AM. Now another user from T2 timezone logs in and views the same record. Will he see it as 3/10/2013 8:30AM or conversion will be applied. I want this field to be shown 3/10/2013 8:30AM regardless of user's timezone.

Best Answer

The datetime will be converted to the logged-in users local timezone if you use apex:outputField to render your date.

You have to use apex:outputText if you don't want any conversion, which means it will be shown in GMT.

It seems you want to convert the datetime to the record creator's timezone for other users? I am not sure why you would want to do that, but if yes you will have to use Apex to get the timezone of the record creator and convert that before displaying to other users.

Related Solutions

[SalesForce] Timezone issue with Datetime Field [again ;-)]

Use Apex to get User's TimeZone and offset time. e.g.

<apex:page controller="TimeZoneController">
    <apex:outputText value="{0,date,dd/MM/yyyy HH:mm:ss}">
        <apex:param value="{!NOW()+offset}"/>
    </apex:outputText>
</apex:page>

public class TimeZoneController{
    public Double offset{get{
        TimeZone tz = UserInfo.getTimeZone();
        //Milliseconds to Day
        return tz.getOffset(DateTime.now()) / (1000 * 3600 * 24.0);
    }}
    public TimeZoneController(){
    }
}

[Reference] https://www.xgeek.net/salesforce/display-datetime-with-timezone-in-visualforce-page/

[SalesForce] Clarification about Timezone Conversion in DateTime

As a baseline Salesforce.com stores all data in the service as UTC.

There are a couple of ways to get to data ..

REST API - When you use the REST API Salesforce returns UTC
SOAP API- When you use the SOAP API Salesforce returns UTC
Standard (OOTB) Page - When you use the standard UI salesforceconverts to the users time zone
VisualForce Page - You do the work in Apex Code.

In code you can run in the system context or the user context depending on where you run. If you run in a system context it is always GMT. If you run as a user context you can then use the user timezone in the data you received.

APEX Code Online help for DateTime date() Returns the Date component of a Datetime in the local time zone of the context user.

dateGMT() Return the Date component of a Datetime in the GMT time zone.
day() Returns the day-of-month component of a Datetime in the local time zone of the context user.
dayGmt() Returns the day-of-month component of a Datetime in the GMT time zone.
dayOfYear() Returns the day-of-year component of a Datetime in the local time zone of the context user.
dayOfYearGmt() Returns the day-of-year component of a Datetime in the GMT time zone.

There are some tools to help in your SOQL Code ... So you can get the datetime in the API users Timezone. Here is an example from the SOQL Reference

SELECT HOUR_IN_DAY(convertTimezone(CreatedDate)), SUM(Amount)
FROM Opportunity
GROUP BY HOUR_IN_DAY(convertTimezone(CreatedDate))

Best Answer

Related Solutions

[SalesForce] Timezone issue with Datetime Field [again ;-)]

[SalesForce] Clarification about Timezone Conversion in DateTime

Related Topic