No announcements
Found 3735716 threads
-
0 VotesCalculate 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 ...Answered | 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
-
0 Votes
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.Answered | 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 -
0 Votes
Calculated Column for Working Days Minus a Date Range
Hi Daniel, I recommend to use three calculated columns to achieve this goal.Answered | 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 -
1 Votes
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 ...Answered | 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 -
0 Votes
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.Answered | 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 -
0 Votes
date - days calculations
Use TimeSpan class to get the difference between two dates: DateTime t1 = DateTime.Today; ...Answered | 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 -
0 Votes
Calculate days between two date query
March 23rd isn't counted.So in fact it is: March - 8 days April - 30 days May – 31 ...Answered | 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 -
1 Votes
Using DateTime to calculate time between two dates
Many thanks Mitja, this code works fine.Answered | 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 -
4 Votes
No of working days between two dates
Yes Sir I have a flag called ISBUSINESS in date dimension.Answered | 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 -
0 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
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 ...Answered | 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 -
1 Votes
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 ...Answered | 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 -
0 Votes
Calculating working days
The free Time Period Library for .NET includes various classes for the calculation of working days.Answered | 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 -
0 Votes
count of working days
Sorry, the PSI does not provide that.Answered | 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 -
0 Votes
Calculate the working hours between 2 date/times.
I will recomend you to use sql query for calculating working hours.Answered | 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 -
1 Votes
How to calculate % of increase between days
Brad, great thanks, your code works well, this is what I wanted.Answered | 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 -
0 Votes
Fucntion to Calculate business days (exclude weekends & holidays) between two days
Thanks..Works perfect... :)Answered | 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 -
0 Votes
calculate business day between two dates
Thank you ~ this worked perfectly ~Answered | 10 Replies | 14506 Views | Created by SQLHelpR - Friday, September 3, 2010 4:51 AM | Last reply by ecm2387 - Monday, April 24, 2017 6:40 PM -
0 Votes
Calculating difference between date columns
You have to use logical functions in your calculated column.Answered | 2 Replies | 14443 Views | Created by Sephiroth0327 - Tuesday, February 1, 2011 5:57 PM | Last reply by Hemendra Agrawal - Wednesday, February 2, 2011 7:27 AM - Items 1 to 20 of 3735716 Next ›
No announcements
