Calculating working days from two dates by looking into business closures and weekends

(0) Share

Report

Posted on by Community Member

Hi Experts,

I have quick query on how to calculate the working days between two dates by excluding the business closure days and weekends. Could someone shed some light how to calculate the difference between two dates. Thanks for your help. I have seen few articles but most of them are like adding no of working days to the current date or created on date.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

Hi,

Did you check this one

hayercrm.blogspot.in/.../dynamics-crm-how-to-add-working-days-by.html

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahen,

Thank you for replying to my query but I have already see the link which you have provided where it is adding working days to created on date. Here I am looking to find the difference between two dates by excluding the business closure days and week ends. Any ideas...? Could you please shed some light.

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (1)

Report

Another option could be to calculate total number of day between two dates using

TimeSpan dateDiff = dateTime1 - dateTime2;

var days = dateDiff.TotalDays;

And then you can use looping to add day one by one to first date and pass it to below method to check if it's holiday.

private bool IsHoliday(DateTime date, IOrganizationService service)

{

DateTime tempClosureDate;

QueryExpression query = new QueryExpression("calendar");

query.ColumnSet = new ColumnSet(true);

ConditionExpression condition = new ConditionExpression();

condition.AttributeName = "name";

condition.Operator = ConditionOperator.Equal;

condition.Values.Add("Business Closure Calendar");

query.Criteria.Conditions.Add(condition);

EntityCollection calendars = service.RetrieveMultiple(query);

EntityCollection calendarrule = calendars[0].GetAttributeValue<EntityCollection>("calendarrules");

foreach (Entity e in calendarrule.Entities)

{

tempClosureDate = (DateTime)e["starttime"];

if (tempClosureDate.ToString("d").Equals(date.ToString("d")))

{

return true;

}

}

return false;

}

}

Hope it will help you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi HIMBAP,

Many Thanks again for your time in answering my query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Many Thanks for your help. I achieved it in a different way.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bellam,

I am facing a similar case. Could you please guide me with your solution? Thanks in advance.

Was this reply helpful? Yes No

Community site session details

Calculating working days from two dates by looking into business closures and weekends

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Calculating working days from two dates by looking into business closures and weekends

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates