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
salesforce_hoonigansalesforce_hoonigan 

APEX or Formula: Adding # of Hours (Custom Number field) to Date/Time Field

Hi All,

Please bear with me since I am a complete newbie in Apex. I have a requirement that whatever number is entered on a custom number field, it will add to hours of Date/Time Field.

Ex. Date/Time field = 07/10/2015 1:37 AM
      Custom_Number__c = 5
      Answer should be = 07/10/2015 6:37 AM

I would be glad if someone can share their codes. Thank you.
Best Answer chosen by salesforce_hoonigan
☯ BonY ☯☯ BonY ☯
Hi,

try this
trigger addhour on future_date__c (before insert, before update) {
   for(future_date__c f1 : trigger.new)
   {
      datetime a = f1.purchase_date__c;
      f1.time__c = a.addHours(integer.valueof(f1.Customer_Number__c));
   }
}

 

All Answers

JeffreyStevensJeffreyStevens
Pretty sure there is an .addHours() method for the DateTime class.

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_datetime.htm

so - in apex:

DateTime newDT = oldDT.addHours(Custom_Number__c);

 
☯ BonY ☯☯ BonY ☯
Hi,

try this
trigger addhour on future_date__c (before insert, before update) {
   for(future_date__c f1 : trigger.new)
   {
      datetime a = f1.purchase_date__c;
      f1.time__c = a.addHours(integer.valueof(f1.Customer_Number__c));
   }
}

 
This was selected as the best answer