[SalesForce] Combine Date from one datetime field with Time from another

I have tried all sorts of proposed solutions but can't seem to find one that works. I receive 2 DateTime fields from an api call and need to take the Date part from one and combine it with the Time part from the other in my upsert trigger into a datetime field.

datetime dtime = opp.AccModifiedTime__c; //1899-12-30 15:38:19

datetime ddate = opp.AccModifiedDate__c; //2014-08-13 00:00:00

It also seems to save these as GMT time when coming in via the API, which is not what I want – this is the local correct time and I want it to display as such. It will display the hours as 3:38 AM (I'm in NZ, so it's 12hrs before GMT). I need it to display as a datetime field of

13/08/2014 03:38 PM

Can anyone help me please?

Best Answer

You want to use the Datetime.newInstance method with parameters Date, Time.

Datetime withDate; // e.g. 2014-08-13 00:00:00
Datetime withTime; // e.g. 1899-12-30 15:38:19

Datetime withBoth = Datetime.newInstance(withDate.date(), withTime.time());

If you wanted to preserve GMT (doesn't sound that way) you could use withTime.timeGMT().

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] Difference between 2 DateTime fields in Hours and Minutes with timezones

Here is what i did, I created a formula field "DateNow__c". In this formula field keep this as datetime field. In order to get EST or CST time zones here you have to find out the time differences in terms of hours. For example, EST time difference would be 4 hours , so i simply made DateNow__c as "NOW()-0.1667" where 0.1667 = 4/24 Similarly for CST, DateNow__c as "NOW()-0.2083" where 0.2083 is 5/24. From this timings i get my local time zones value,

Why i did this is because When i used something like this "TEXT((NOW()-0.2083) - LastModifiedDate)" did not give me the desired output.

Step 2: Now to determine the diff in hours and minutes. Normally difference will give some decimal values like 5.52 where 5 is the no. of days , 0.5 in terms of hours and 0.02 in terms of minutes. The below formula will give me the difference in hours and minutes. For example, Date A is 9/22/2014 5:40 AM and Date B is 9/22/2014 8:00 AM My result will be : 2.20 where 2 is the hours and .20 is the minutes. For example, Date A is 9/21/2014 5:40 AM and Date B is 9/22/2014 8:00 AM My result will be : 26.20 where 26 is the hours and .20 is the minutes. (even day wil be converted to hours)

(FLOOR(( DateNow__c - SomeDatetime__c)*24)) 
+
ROUND((((
((DateNow__c - SomeDatetime__c)*24)-
FLOOR((DateNow__c - SomeDatetime__c)*24))
*60)/100),2)

here FLOOR(..) - will give me the hours. ROUND(..,2) will give me the minutes in 2 decimal places. Hope this will do good to you in some way.

Best Answer

Related Solutions

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

[SalesForce] Difference between 2 DateTime fields in Hours and Minutes with timezones

Related Topic