No announcements
Found 3735734 threads
-
0 VotesCalculate Total Days from Start and End Date
Hi SharePointTech, You can create a calculated column named Totaldays, and set formula as “DATEDIF([Startdate],[Enddate],"d")”.Answered | 5 Replies | 1172 Views | Created by SharePointTech - Tuesday, May 3, 2016 5:28 AM | Last reply by Dean_Wang - Wednesday, May 18, 2016 8:46 AM
-
1 Votes
Calculate the number of business days between two dates in power pivot
Add a column named workingday with the expression below to the Calendar table that 1 for workdays and 0 for non-workdays: =if([WeekDay],1,0)Add a column with the expression below to ...Answered | 2 Replies | 4728 Views | Created by PerplexedDev - Thursday, May 14, 2015 7:02 PM | Last reply by Katherine Xiong - Friday, May 15, 2015 3:26 AM -
4 Votes
Trouble calculating date/time between two dates.
I also have another field in the database which is the duration or lapsed time in seconds between the start date and the end date.Answered | 13 Replies | 11374 Views | Created by DblR - Thursday, October 28, 2010 10:12 PM | Last reply by Mohamed Irshad - Thursday, December 2, 2010 4:02 AM -
2 Votes
Calculating number of days between dates
Is it possible to use a variable with Mod?Answered | 7 Replies | 1969 Views | Created by Gulfvet91 - Wednesday, August 8, 2012 3:23 AM | Last reply by Ellen Ramcke - Wednesday, August 8, 2012 8:04 PM -
0 Votes
SharePoint designer workflow-How to get working days between two dates?
Hi, There is no OOB solution to calculate working days in SharePoint workflow, if you don’t want to use third-party extension/product.Answered | 2 Replies | 923 Views | Created by Vishal_Goyal - Wednesday, May 8, 2019 9:34 AM | Last reply by Lee__li - Thursday, May 9, 2019 2:55 AM -
4 Votes
Calculate the days between today and specific day.
I already did a blog post about it and it's cross-posted to NothingButSharePoint.com.Answered | 15 Replies | 7929 Views | Created by emfuentes27 - Friday, January 4, 2013 4:28 PM | Last reply by Yizzelda - Wednesday, December 17, 2014 8:36 PM -
0 Votes
Calculate the date between the CreatedDate and the Sysdate
I have several 'Aging' reports that I calculate the elapsed time from key events (created date, approved date, closed date) and use that to report a ...Answered | 1 Replies | 625 Views | Created by Custom Field Calculating dates - Tuesday, September 1, 2015 3:02 PM | Last reply by Jim Christenson - Tuesday, September 1, 2015 3:45 PM -
2 Votes
Counting days in between with some dates excluded
Using calendar table with all dates included is easier.Answered | 3 Replies | 956 Views | Created by Nilfons - Thursday, April 24, 2014 1:49 PM | Last reply by Naomi N - Thursday, April 24, 2014 3:13 PM -
9 Votes
calculate number of months,weeks,days for two dates
Imho i'd be using a date dimension if you're doing a lot of date manipulation.Answered | 23 Replies | 12072 Views | Created by JR1811 - Wednesday, August 15, 2012 6:02 PM | Last reply by JR1811 - Thursday, August 16, 2012 9:04 PM -
0 Votes
Calculated measure between two dates
Here's an example summing a measure over a particular date range (Adventure Works) WITH MEMBER [Measures].Answered | 3 Replies | 5014 Views | Created by Andreas_Schneider - Sunday, September 5, 2010 4:59 PM | Last reply by Josh Ashwood - Monday, September 13, 2010 11:16 PM -
6 Votes
Calculating % change between 2 dates
We used this formula to retrieve the last price available at the respective dates.Answered | 6 Replies | 1471 Views | Created by עמיתת - Thursday, July 16, 2015 10:14 AM | Last reply by עמיתת - Tuesday, August 4, 2015 7:06 PM -
19 Votes
How do I calculate the number of days between two dates in C#?
I've always reverted back to the Delphi TDateTime class to do my date calculations, but now that I know about TimeSpan I can do it all in C#.NET.Answered | 9 Replies | 184143 Views | Created by Josh Ledgard - Friday, April 8, 2005 12:32 AM | Last reply by Louis.fr - Sunday, May 9, 2010 11:42 PM -
2 Votes
Calculated field to capture +/- 28 days from date
Hi William, According to your description, you want to create a calculated field to return ‘yes’ when the gap between date1 and date2 is within 28 ...Answered | 2 Replies | 759 Views | Created by William Faulkner2 - Friday, September 18, 2015 7:23 AM | Last reply by Qiuyun Yu - Monday, September 21, 2015 6:24 AM -
0 Votes
Calculating holiday days taken
Hi as i promised, here are the scripts for : get number of vacation days between 2 datesAnswered | 2 Replies | 1134 Views | Created by Johnweet - Friday, October 16, 2015 10:35 AM | Last reply by romeo donca - Tuesday, October 20, 2015 8:07 PM -
1 Votes
calculating the difference between two dates
[Time between ] + DTOC( d1 ) + [ and ] + DTOC( d2 ) ?Answered | 7 Replies | 12583 Views | Created by zahj - Wednesday, March 21, 2007 3:14 AM | Last reply by Tom Borgmann - Wednesday, April 4, 2012 1:35 PM -
0 Votes
Calculate difference between two dates excluding weekends using calculated column in SP 2013
Use the following formula to calculate that workdays between two dates.Answered | 5 Replies | 1293 Views | Created by laxmikant.b2 - Monday, February 4, 2019 12:04 PM | Last reply by Linda ZL - Thursday, February 7, 2019 7:12 AM -
5 Votes
Can I write a future date and calculate how many days until that date using Small Basic?
Have look back to late December 2011 at the thread Trying to create a 'days to go' calculator, but little successAnswered | 3 Replies | 3460 Views | Created by RobertCharlesCrysler - Wednesday, January 25, 2012 4:55 PM | Last reply by Nevin Janzen - Thursday, January 26, 2012 3:23 AM -
0 Votes
Calculate with working days
How to setup a calculated measure, that returns the working days for the whole year?Answered | 4 Replies | 6860 Views | Created by SSCS - Wednesday, June 24, 2009 2:26 PM | Last reply by SSCS - Tuesday, August 4, 2009 11:09 AM -
1 Votes
TSQL Insert Days between Dates
Hello, Try DateDiff function to get days between dates.Answered | 4 Replies | 3843 Views | Created by vsla - Thursday, March 29, 2012 10:11 PM | Last reply by SteveJohn14 - Friday, March 30, 2012 3:07 AM -
0 Votes
Problem with calculated column (for date) as no. of days remaining for due date are not updated everyday.
However the value is not getting refreshed the next day.Answered | 4 Replies | 4084 Views | Created by Amien123 - Sunday, May 31, 2015 8:33 AM | Last reply by Danish Islam (Danny) - Monday, June 1, 2015 10:42 AM
No announcements
