Dynamics Community Forum Thread Details

Calculating working days between two date and time fields by excluding Business holidays and weekends

Hi,

I am trying to find the no of working days between two date time fields. Please suggest me how I can achieve it.

                    if (!IsWorkingDayOfWeek(date))
                    {
                        if (num1 >= 1)
                        {
                            --num1;
                            num2 -= 1440;
                        }
                        else
                        {
                            num1 = 0;
                            num2 = 0;
                        }
                    }
        
        /// <summary>
        /// Get Business Closure Calendar Rules
        /// </summary>
        private  IEnumerable<Entity> GetBusinessClosureCalendarRules(IWorkflowContext context, IOrganizationService service)
        {
            // Get Organization Business Closure Calendar Id
            var organization = service.Retrieve("organization", context.OrganizationId, new ColumnSet("businessclosurecalendarid"));

            var query = new QueryExpression("calendar")
            {
                ColumnSet = new ColumnSet(true),
                Criteria = new FilterExpression()
            };

            // Add condition to get Get Calander where CalanderId is equal to Organization's businessclosurecalendarid
            query.Criteria.AddCondition(new ConditionExpression("calendarid", ConditionOperator.Equal, organization["businessclosurecalendarid"].ToString()));

            // Get Calendar
            var businessClosureCalendar = service.RetrieveMultiple(query).Entities[0];
            return businessClosureCalendar == null || businessClosureCalendar.GetAttributeValue<EntityCollection>("calendarrules") == null ? null : businessClosureCalendar.GetAttributeValue<EntityCollection>("calendarrules").Entities;
        }       

      
        private bool IsWorkingDayOfWeek(DateTime date)
        {
            DayOfWeek dayOfWeek = date.DayOfWeek;
            return dayOfWeek != DayOfWeek.Saturday && (uint)dayOfWeek > 0U;
        }

Quick Links

Leaderboard