No announcements

### Calculate Date for 8 weeks prior

I'd like to create a calculated measure that averages a column over the previous 8 weeks.  I've tried a bunch of the date functions, but can't quite get the proper ...
| 2 Replies | 5425 Views | Created by Henry Winkler IV - Monday, May 14, 2012 11:12 PM | Last reply by Henry Winkler IV - Monday, May 28, 2012 7:17 PM

### how to calculate 6 weeks sales prior to starting of fiscal year.i

to have a full date table covering all dates present in your model, or more. You should have a measure that returns the first day of the fiscal year, say [FirstDay]. To ...
| 1 Replies | 682 Views | Created by gawtam kumar - Wednesday, April 6, 2016 12:53 AM | Last reply by Michiel Rozema - NL - Wednesday, April 6, 2016 6:11 PM

### How to calculate Prior Year To Date in SSRS

reports to SSRS. I can't seem to find an easy way to do a calculation for Prior Year to Date or Prior Year Month to Date in SSRS. Can somebody ...
| 1 Replies | 1637 Views | Created by AquaNewbie - Wednesday, April 15, 2015 3:51 PM | Last reply by Patrick Hurst - Wednesday, April 15, 2015 4:44 PM

### Calculate Months,Weeks and Days

DECLARE  @StartDate   DATE  = '20120725' DECLARE  @EndDate     DATE  = '20120902' I Need ...
| 4 Replies | 2392 Views | Created by Jitta Rohan - Thursday, August 16, 2012 9:36 AM | Last reply by Satheesh Variath - Thursday, August 16, 2012 11:20 AM

### Calculate weeks between Two dates

Hello , How can we calculate Number of weeks between two dates in C#. Thank you in advance.
| 4 Replies | 23871 Views | Created by Preetam - Wednesday, October 24, 2007 4:05 AM | Last reply by Johnthecoder - Tuesday, July 26, 2011 11:45 PM

### Calculate Date

Hello all, I am trying to calculate a Due Date by adding a Date with an integer for example 01/06/10 + 14 = 15/06/10, but i also want to be able ...
| 1 Replies | 4285 Views | Created by Supp85 - Monday, June 14, 2010 8:53 AM | Last reply by BernieHunt - Monday, June 14, 2010 12:13 PM

### calculate number of months,weeks,days for two dates

How to Calculate number of months,weeks,days for a date range Assume a calendar month is a month  Example ...
| 23 Replies | 11172 Views | Created by JR1811 - Wednesday, August 15, 2012 6:02 PM | Last reply by JR1811 - Thursday, August 16, 2012 9:04 PM

### Date help (weeks to months)

I have a table with scheduled work hours, there is a start date and an end date and a field that indicates the date of the monday for that ...
| 1 Replies | 4995 Views | Created by Nalani - Monday, February 7, 2011 9:59 PM | Last reply by Chintak Chhapia - Monday, February 7, 2011 11:28 PM

### DateDiff To calculate days between weeks

I am able to achieve this as well by creating a new data set and then creating a date filter for the data set to be between two weeks/ days: Expression: ...
| 5 Replies | 906 Views | Created by Bright Light1 - Thursday, December 7, 2017 10:18 PM | Last reply by Bright Light1 - Friday, December 8, 2017 6:03 PM

### Calculate how many weeks during a month

Is there anyway I could work out the number of weeks per month so for example... during this date period 2011-06-01 and 2011-07-01 i need to know how ...
| 8 Replies | 4755 Views | Created by Sam233 - Friday, July 8, 2011 11:24 AM | Last reply by Erland Sommarskog - Friday, July 8, 2011 10:35 PM

### Date from plus 40 weeks

Your title says: Current date minus 40 weeks. Is it the DATE_FROM that should then be 40 weeks away from the current date? i.e. today 2014-07-28 ...
| 4 Replies | 862 Views | Created by MVP_88 - Monday, July 28, 2014 8:25 AM | Last reply by MVP_88 - Monday, July 28, 2014 9:12 AM

### Calculate number of weeks between dates

Can you try the below query?  Please let me know the query works for you DECLARE @EndDateTime DATETIME = '8/25/2014' DECLARE @StartDateTime DATETIME = ...
| 6 Replies | 1875 Views | Created by Nichesl - Wednesday, August 27, 2014 5:03 PM | Last reply by --CELKO-- - Wednesday, August 27, 2014 7:32 PM

### Calculate Date Difference

: one is document creation date and other notification date. They both are variables. I wanted to know how to calculate the difference ...
| 1 Replies | 492 Views | Created by Subjectified - Thursday, November 6, 2014 2:19 PM | Last reply by Mr. Zator - Thursday, November 6, 2014 2:34 PM

### calculate the future date??

Hi yangyeswar, According to your description, you want to calculate the Output value based on the Warranty Initial Period value and Warranty Start Date value, is ...
| 1 Replies | 494 Views | Created by yangyeswar - Monday, June 6, 2016 11:30 AM | Last reply by Weiwei Cai - Tuesday, June 7, 2016 9:11 AM

### How to calculate date

hi, i have todays date and a period of day number for example 30 days. i want calculate the date of 30 days back from now. thanks a lot.
| 2 Replies | 3196 Views | Created by u.selamoglu - Monday, July 9, 2007 7:01 AM | Last reply by u.selamoglu - Monday, July 9, 2007 7:26 AM

### Calculate Date

your form   I agree with roger though regarding standard procedures, but you could use this code in your query to calculate two years (24 ...
| 3 Replies | 3477 Views | Created by jdickerson - Friday, December 3, 2010 4:09 PM | Last reply by Graham R Seach - Saturday, December 4, 2010 9:49 AM

### Calculate Date of Easter for any year.

Is anyone interested in seeing my code for a program that will calculate the date of Easter for any year? I currently have it only for the ...
| 2 Replies | 2507 Views | Created by STEAM01 - Monday, August 31, 2009 4:26 AM | Last reply by STEAM01 - Tuesday, September 1, 2009 2:03 AM

### USP For 4 weeks

Using a Last Seen Date for an example I want to create a Procedure that calculates the last 4 weeks seen by getdate and if not seen in ...
| 3 Replies | 891 Views | Created by ODIAZ0305 - Monday, August 26, 2013 2:36 PM | Last reply by Allen Li - MSFT - Wednesday, August 28, 2013 1:47 AM