No announcements

Calculate working days between dates using PSI

If you find which calendar a project uses (with Project.ReadProject), and which calendar an assigned resource uses, you could use ...
| 1 Replies | 11053 Views | Created by Baloodevil - Monday, November 15, 2010 9:59 PM | Last reply by Jim Corbin - Tuesday, November 16, 2010 5:14 AM

Calculating number of days between two dates

I ended up writing a stored procedure to calculate & store the number of days at the fiscal month level.
| 2 Replies | 6714 Views | Created by ty-son - Monday, May 23, 2011 2:53 AM | Last reply by ty-son - Monday, May 23, 2011 10:22 PM

Calculated Column for Working Days Minus a Date Range

Hi Daniel, I recommend to use three calculated columns to achieve this goal.
| 2 Replies | 909 Views | Created by Daniel_Rondo - Tuesday, June 14, 2016 6:18 AM | Last reply by Victoria Xia - Wednesday, June 22, 2016 11:05 AM

Calculate Days Difference between two dates

Hi Sid, Based on your description, you want to calculate days difference between two dates, foe example : if you want to get day ...
| 3 Replies | 1443 Views | Created by Sid Williams - Thursday, October 19, 2017 9:57 AM | Last reply by Cherry Bu - Friday, October 20, 2017 1:56 AM

Calculate working days by given date and hours

You may want to start from Calculating number of workdays between 2 datesPremature optimization is the root of all evil in programming.
| 4 Replies | 3982 Views | Created by Ajai_N - Tuesday, April 13, 2010 12:29 PM | Last reply by MayurGupta - Wednesday, April 14, 2010 11:06 AM

date - days calculations

Use TimeSpan class to get the difference between two dates: DateTime t1 = DateTime.Today; ...
| 4 Replies | 1939 Views | Created by CanAnn - Wednesday, October 12, 2011 2:10 PM | Last reply by Mitja Bonca - Wednesday, October 12, 2011 3:19 PM

Calculate days between two date query

March 23rd isn't counted.So in fact it is: March  - 8 days April -  30 days May – 31 ...
| 6 Replies | 2064 Views | Created by Wass5 - Monday, February 8, 2016 11:42 AM | Last reply by Shaheen Karatela - Monday, February 8, 2016 4:54 PM

Using DateTime to calculate time between two dates

Many thanks Mitja, this code works fine.
| 6 Replies | 17301 Views | Created by kenpopaul - Thursday, August 11, 2011 8:06 AM | Last reply by kenpopaul - Monday, August 15, 2011 11:21 AM

No of working days between two dates

Yes Sir I have a flag called ISBUSINESS in date dimension.
| 4 Replies | 1325 Views | Created by Murali dhar - Monday, January 27, 2014 6:29 PM | Last reply by Visakh16 - Monday, January 27, 2014 6:55 PM

Calculate the days difference between 2 dates

Best regards, Patrick TechNet Community Support Please remember to mark the replies as answers if they help, and unmark the answers ...
| 3 Replies | 586 Views | Created by KurtAllen - Wednesday, May 11, 2016 1:27 PM | Last reply by Patrick_Liang - Friday, May 13, 2016 1:41 AM

Add working days to a date

Our user wants to make a report of all the tasks containing the startdate, number of days that is allowed to complete the task and a new calculated field 'enddate' that is ...
| 3 Replies | 1676 Views | Created by Wim Wensel - Tuesday, January 12, 2016 2:25 PM | Last reply by Wim Wensel - Wednesday, January 13, 2016 9:40 AM

Calculate working days function

Hi I have a function which will calculate the number of working days (only weekends not bank holidays). you pass the function a start and an end ...
| 12 Replies | 4691 Views | Created by PaulNic - Wednesday, July 22, 2009 11:39 PM | Last reply by PaulNic - Thursday, July 23, 2009 11:24 AM

Want to Calculate a Date with System Date less than two working days

Hallo Uri Dimant,     Thanks for ur answer. but i can't use your query, because i'm using Sql server editor. so when i run this shown error ...
| 3 Replies | 3260 Views | Created by Raja CRT - Thursday, April 5, 2012 10:17 AM | Last reply by Raja CRT - Monday, April 9, 2012 12:47 PM

Calculating working days

The free Time Period Library for .NET includes various classes for the calculation of working days.
| 8 Replies | 16432 Views | Created by Shekhar R - Thursday, March 10, 2011 9:38 AM | Last reply by Jani Giannoudis - Saturday, March 26, 2011 8:15 AM

count of working days

Sorry, the PSI does not provide that.
| 1 Replies | 10338 Views | Created by Andromeda61 - Thursday, March 17, 2011 11:27 AM | Last reply by Jim Corbin - Friday, March 18, 2011 3:32 AM

Calculate the working hours between 2 date/times.

I will recomend you to use sql query for calculating working hours.
| 4 Replies | 3290 Views | Created by msegars - Tuesday, December 10, 2013 2:17 PM | Last reply by msegars - Wednesday, December 11, 2013 9:27 PM

How to calculate % of increase between days

Brad, great thanks, your code works well, this is what I wanted.
| 9 Replies | 8647 Views | Created by kapiszon2929 - Wednesday, March 17, 2010 7:35 PM | Last reply by kapiszon2929 - Thursday, March 18, 2010 8:57 AM

Fucntion to Calculate business days (exclude weekends & holidays) between two days

Thanks..Works perfect... :)
| 6 Replies | 4607 Views | Created by app087 - Monday, January 26, 2015 4:05 PM | Last reply by app087 - Wednesday, January 28, 2015 1:10 PM