Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CASE(MOD( Start_date__c - DATE(1985,6,24),7),
- 0 , CASE( MOD( End_date__c - Start_date__c, 7),1,0,2,0,3,0,4,0,5,1,6,2,0),
- 1 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,0,2,0,3,0,4,0,5,2,2),
- 2 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,0,2,0,3,1,2),
- 3 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,0,2,1,2),
- 4 , CASE( MOD( End_date__c - Start_date__c, 7),0,0,1,1,2),
- 5 , CASE( MOD( End_date__c - Start_date__c, 7),0,1,2),
- 6 , CASE( MOD( End_date__c - Start_date__c, 7),6,2,1),
- 999)
- +
- (FLOOR(( End_date__c - Start_date__c )/7)*2)
- (IF(TEXT(Start_date__c)= TEXT(End_date__c) , 0.0, End_date__c - Start_date__c)) - Weekend__c
- Date txnDate = System.today();
- Date systemDate = txnDate.addDays(10);
- Integer holidaysCount = 0;
- BusinessHours bh;
- List<BusinessHours> temp = [SELECT ID, Name, IsDefault, IsActive From BusinessHours
- WHERE IsDefault = true
- OR Name = 'BANK'];
- for (BusinessHours b : temp) {
- if (b.IsDefault) {
- bh = b;
- }
- }
- while (txnDate != systemDate) {
- Datetime now = Datetime.newInstance(txnDate.year(), txnDate.month(), txnDate.day(), 0, 0, 0);
- Boolean isHoliday = !BusinessHours.isWithin(bh.Id, now);
- System.debug('The value of isHoliday is : '+isHoliday);
- if (isHoliday) {
- holidaysCount++;
- }
- txnDate = txnDate.addDays(1);
- }
- System.debug('The holidays are : '+holidaysCount);
- weekdays + weekenddays = calendardays
- public static Date changeWeekendTaskDueDate(Date thedate)
- {
- Datetime dt = DateTime.newInstance(thedate, Time.newInstance(0, 0, 0, 0));
- String dayOfWeek=dt.format('E');
- Integer offset = 0;
- if(dayOfWeek == 'Sat')
- {
- offset = 2;
- }
- else if(dayOfWeek == 'Sun')
- {
- offset = 1;
- }
- return thedate + offset;
- }
Add Comment
Please, Sign In to add comment