Advertisement
Guest User

Untitled

a guest
Aug 1st, 2014
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. BusinessHours bh = [SELECT id,SundayStartTime, MondayStartTime, TuesdayStartTime,
  2. WednesdayStartTime, ThursdayStartTime, FridayStartTime,
  3. SaturdayStartTime, SundayEndTime, MondayEndTime,TuesdayEndTime,
  4. WednesdayEndTime, ThursdayEndTime, FridayEndTime,SaturdayEndTime
  5. From BusinessHours
  6. Where IsDefault=true];
  7.  
  8. Datetime inTime = custom date time field 1
  9. Datetime outTime = Custom date time field 2;
  10.  
  11. long businessMillisecondsDiff = BusinessHours.diff(bh.Id, inTime, outTime);
  12. decimal businessHoursDiff = businessMillisecondsDiff / (1000.0*60.0*60.0);
  13.  
  14. custom_date_time_field__c = businessHoursDiff ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement