[SalesForce] Datetime input field cast to another timezone

Is there a way to cast the input of a timedate field to another timezone's GMT…?

If the user is in say: MDT, an input of 12:00, will be saved as 18:00, but if I want that value to be in EDT, I need the value to be saved as 16:00GMT

Best Answer

The datetime in salesforce is always stored in GMT (UTC). The time is corrected to the users time zone when displaying it on the UI.

Datetime GMTDate = 
  Datetime.newInstanceGmt(2011,6,1,12,1,5);
String strConvertedDate = 
  GMTDate.format('MM/dd/yyyy HH:mm:ss', 
                 'America/New_York');
// Date is converted to the new time zone and is //adjusted for daylight saving time.

Valid time zone values for the timezone argument are the time zones of the Java TimeZone class that correspond to the time zones returned by the TimeZone.getAvailableIDs method in java

Related Solutions

[SalesForce] Timezone issue with Datetime field in salesforce

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.

[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/

Best Answer

Related Solutions

[SalesForce] Timezone issue with Datetime field in salesforce

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

Related Topic