Guest User

Untitled

a guest
Jun 21st, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. CASE(MOD( Start_date__c - DATE(1985,6,24),7),
  2. 0 , CASE( MOD( End_date__c - Start_date__c, 7),1,0,2,0,3,0,4,0,5,1,6,2,0),
  3. 1 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,0,2,0,3,0,4,0,5,2,2),
  4. 2 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,0,2,0,3,1,2),
  5. 3 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,0,2,1,2),
  6. 4 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,1,2),
  7. 5 , CASE( MOD( End_date__c - Start_date__c, 7),0,1,2),
  8. 6 , CASE( MOD( End_date__c - Start_date__c, 7),6,2,1),
  9. 999)
  10. +
  11. (FLOOR(( End_date__c - Start_date__c )/7)*2)
  12.  
  13. (IF(TEXT(Start_date__c)= TEXT(End_date__c) , 0.0, End_date__c - Start_date__c)) - Weekend__c
  14.  
  15. Date txnDate = System.today();
  16. Date systemDate = txnDate.addDays(10);
  17.  
  18. Integer holidaysCount = 0;
  19. BusinessHours bh;
  20. List<BusinessHours> temp = [SELECT ID, Name, IsDefault, IsActive From BusinessHours
  21. WHERE IsDefault = true
  22. OR Name = 'BANK'];
  23. for (BusinessHours b : temp) {
  24. if (b.IsDefault) {
  25. bh = b;
  26. }
  27. }
  28. while (txnDate != systemDate) {
  29. Datetime now = Datetime.newInstance(txnDate.year(), txnDate.month(), txnDate.day(), 0, 0, 0);
  30. Boolean isHoliday = !BusinessHours.isWithin(bh.Id, now);
  31. System.debug('The value of isHoliday is : '+isHoliday);
  32. if (isHoliday) {
  33. holidaysCount++;
  34. }
  35. txnDate = txnDate.addDays(1);
  36. }
  37. System.debug('The holidays are : '+holidaysCount);
  38.  
  39. weekdays + weekenddays = calendardays
  40.  
  41. public static Date changeWeekendTaskDueDate(Date thedate)
  42. {
  43. Datetime dt = DateTime.newInstance(thedate, Time.newInstance(0, 0, 0, 0));
  44. String dayOfWeek=dt.format('E');
  45. Integer offset = 0;
  46.  
  47. if(dayOfWeek == 'Sat')
  48. {
  49. offset = 2;
  50. }
  51. else if(dayOfWeek == 'Sun')
  52. {
  53. offset = 1;
  54. }
  55.  
  56. return thedate + offset;
  57. }
Add Comment
Please, Sign In to add comment