No announcements
Found 4081506 threads
-
7 VotesGet Week number for month
The first week of the month in this example can be a partial week (for instance, the first week of the ...Answered | 15 Replies | 50892 Views | Created by Shobha P - Friday, November 21, 2008 11:10 AM | Last reply by dpminusa - Sunday, February 21, 2016 3:56 PM
-
1 Votes
How to get this in ssrs reports "Filter Month defaults to the Month of the previous week and Filter Week and Day defaults to the previous week
And we can use DatePart function to return the week of year.Answered | 7 Replies | 4639 Views | Created by NaveenMSBI - Tuesday, September 24, 2013 5:24 PM | Last reply by Mohan Kumar - CSA - Thursday, September 26, 2013 5:59 AM -
1 Votes
Calendar Week Versus Week of The Month
I think I know how to address this, but before I post my solution, I want to try it out in my environment.Answered | 4 Replies | 648 Views | Created by ansonee - Monday, August 8, 2016 4:12 PM | Last reply by ansonee - Wednesday, August 10, 2016 2:32 AM -
1 Votes
How to split month in to weeks
Better to make a table and define calendar there ... may be with week no.Answered | 2 Replies | 7326 Views | Created by Royal Thomas - Friday, November 18, 2011 4:55 PM | Last reply by Kalman Toth - Monday, November 21, 2011 12:29 AM -
1 Votes
Retrieve weeks in month for next month
Hi Andrew I believe this example from Adventure Works illustrates how to go about it: WITH MEMBER [Measures].Answered | 3 Replies | 5732 Views | Created by Andrew Oliver - Tuesday, May 17, 2011 5:06 AM | Last reply by Andrew Oliver - Tuesday, May 17, 2011 11:03 PM -
2 Votes
how to get last date of month and week number
Declare @Year Int, @Month Int,@Day Int Select @Year = 2012,@Month = 2,@Day = 1 Select DATEADD(dd,-1, DateAdd(M,1,Cast(Cast(@Year As ...Answered | 3 Replies | 3716 Views | Created by RajeshBodduluri - Tuesday, September 25, 2012 5:15 AM | Last reply by Dhaval Chauhan - Saturday, September 29, 2012 4:22 AM -
6 Votes
Start week of the month for a given week
If you decide/know what is the answer (what is the first day of the week for you), then you can get simple solution without calendar table.Answered | 33 Replies | 1360 Views | Created by Jamesit0 - Thursday, July 23, 2015 5:10 PM | Last reply by --CELKO-- - Friday, July 24, 2015 4:25 PM -
4 Votes
how to find week number of month
http://berezniker.com/content/pages/sql/microsoft-sql-server/week-number-month DECLARE @dt DATETIME, @WeekOfMonth TINYINT SET @dt = ...Answered | 5 Replies | 4304 Views | Created by SHYAM GUNDU - Tuesday, October 18, 2011 3:14 AM | Last reply by Naomi N - Tuesday, October 18, 2011 7:10 PM -
0 Votes
Filtering by week instead of month
I put in two weeks back and I get data from the 20th week and the 24th week.Answered | 12 Replies | 8017 Views | Created by meef - Wednesday, July 7, 2010 1:04 PM | Last reply by Kalman Toth - Friday, July 16, 2010 8:20 PM -
0 Votes
Getting data from a week and also that same week in previous months.
Of course, you can limit the generation of dates as per your requirement.Answered | 7 Replies | 1404 Views | Created by vqcheese - Thursday, September 5, 2013 8:05 PM | Last reply by SQLZealots - Wednesday, January 29, 2014 1:20 PM -
0 Votes
How can I get the months between a span?
Hope this helps http://stackoverflow.com/questions/11930565/list-the-months-between-two-dates Thanks & Regards, Prasanna ...Answered | 1 Replies | 846 Views | Created by MLyons10 - Wednesday, February 6, 2013 7:06 PM | Last reply by shriprasanna - Wednesday, February 6, 2013 7:12 PM -
3 Votes
List Week and Month Names
Using "select datename(month,getdate())" you can get the current month name.Answered | 12 Replies | 7359 Views | Created by Sharath048 - Wednesday, May 11, 2011 5:42 AM | Last reply by Kalman Toth - Monday, May 16, 2011 9:21 PM -
1 Votes
How to get the week number in a month using t-sql in sql server
The alternative I would prefer is to build a calendar table.Answered | 3 Replies | 16785 Views | Created by venugopalrr - Thursday, August 11, 2011 1:19 PM | Last reply by Tom Cooper - Thursday, August 11, 2011 1:43 PM -
2 Votes
Number of Weeks in Month
@Joel: Your algorithm won't handle the occasional "6-week month", when the 1st is on Saturday and the month has 30 or 31 days, or the 1st is on ...Answered | 6 Replies | 17878 Views | Created by Madasamyponraj - Monday, November 26, 2012 11:48 AM | Last reply by Joel Engineer - Monday, November 26, 2012 1:56 PM -
1 Votes
How to get consecutive Week number for every month in FY-2011-2012
but, i want to generate FY with week count and i want to generate in <td> tag..Answered | 3 Replies | 6838 Views | Created by gani7787 - Tuesday, April 17, 2012 7:08 AM | Last reply by gani7787 - Wednesday, April 18, 2012 9:18 AM -
0 Votes
How To Find Month Number using week number
declare @Year char(4) declare @WeekNumber tinyint Set @Year = '2012' Set @WeekNumber = 4 select RIGHT('00' + CAST(month(dateadd(wk,@WeekNumber,@Year + '/01/01')) as ...Answered | 4 Replies | 2048 Views | Created by prateep reddy - Thursday, November 29, 2012 1:28 PM | Last reply by prateep reddy - Thursday, November 29, 2012 2:10 PM -
0 Votes
assigning week of month in SQL
Also, please see the assumption that I made in my post - "If I understand correctly what you want is for each month, day 1 - 7 would be 1; 8 - ...Answered | 8 Replies | 5673 Views | Created by jaeya611 - Wednesday, October 5, 2011 10:01 PM | Last reply by Anooka - Wednesday, October 12, 2011 3:48 PM -
1 Votes
Finding Week of the Month
"Fourth Week") ElseIf weekNum > 4 Then MsgBox("Last Week") End IfAnswered | 2 Replies | 3342 Views | Created by Kashif Chotu - Sunday, May 10, 2009 6:12 AM | Last reply by Paramu - Sunday, May 10, 2009 7:29 AM -
0 Votes
Calculate how many weeks during a month
I guess that depends on which day your weeks start on.Answered | 8 Replies | 4880 Views | Created by Sam233 - Friday, July 8, 2011 11:24 AM | Last reply by Erland Sommarskog - Friday, July 8, 2011 10:35 PM -
0 Votes
Missing logic for week and months in MDX
Thank you, I have a query for week and month individually but I need to merge both of them to create reports at the same I need to pass parameters for ...Answered | 7 Replies | 2690 Views | Created by BandSr - Monday, October 24, 2011 9:04 PM | Last reply by Santosh Kumar Joshi - Tuesday, October 25, 2011 8:05 AM - Items 1 to 20 of 4081506 Next ›
No announcements
