No announcements
Found 1136966 threads
-
0 VotesWeek Start Date and End Date
select GETDATE() - datepart(weekday, GETDATE() + @@datefirst - 1) + 1 as week_start_monday The @@DATEFIRST in SQL Server is one of the Date and Time ...Answered | 6 Replies | 645 Views | Created by srinivas_ch - Monday, May 4, 2020 10:02 AM | Last reply by Jeff Williams 3188 - Monday, May 4, 2020 7:08 PM
-
0 Votes
Start date of last 13th week
Start date will have 1st date of last 13th WK End date will have last date of last 15th WKAnswered | 6 Replies | 1329 Views | Created by BI_Support - Friday, July 26, 2013 8:32 AM | Last reply by SQLZealots - Friday, July 26, 2013 9:21 AM -
1 Votes
Get Start date and week End date for particular Week number and year
Suppose user want to schedule on week = 1, Year = 2009 here output comes , Start date = 1/1/2009 and enddate = 3/1/2009.Answered | 13 Replies | 20037 Views | Created by sunDAC - Wednesday, April 1, 2009 10:49 AM | Last reply by NicoJuicy - Wednesday, January 9, 2013 7:47 AM -
0 Votes
Parallel Period and Week to date
i, Week to date for my current week returns sales from week start to previous day .Answered | 8 Replies | 3567 Views | Created by Kennilove - Friday, November 18, 2011 9:16 AM | Last reply by Challen Fu - Friday, November 25, 2011 2:11 AM -
1 Votes
Start and End date of a Given week of a Month
You input any calendar date, find the week-within-year column and return the dates that match on a LIKE predicate.Answered | 13 Replies | 2087 Views | Created by Sanjaya Kumar Mohapatra - Tuesday, March 19, 2013 6:48 AM | Last reply by --CELKO-- - Tuesday, March 19, 2013 4:45 PM -
0 Votes
Group by date but display the week date
Pull the pay data group by day and also calculate the week dates range value in one column.Answered | 4 Replies | 3888 Views | Created by Ravishankar Polepalli - Friday, April 20, 2012 2:00 AM | Last reply by Ravishankar Polepalli - Saturday, April 21, 2012 2:31 AM -
6 Votes
Start week of the month for a given week
I loop 1-8 which mean any culture that there is (there are only 7 days so each culture can use different day as the starting day of the week).Answered | 33 Replies | 1336 Views | Created by Jamesit0 - Thursday, July 23, 2015 5:10 PM | Last reply by --CELKO-- - Friday, July 24, 2015 4:25 PM -
0 Votes
Date Week in Report Builder
You may need to convert your month numbers to dates so you can format them with date format strings--use Edit Formula and the DATE function to do this (you can just specify ...Answered | 6 Replies | 7062 Views | Created by mike950 - Friday, April 17, 2009 2:08 PM | Last reply by Aaron Meyers - Tuesday, April 21, 2009 1:02 AM -
0 Votes
Week number from date
If I am executing query mentioned above, Week is getting started on Sunday to Saturday but How to write a query if I want to start my week from Monday ...Answered | 8 Replies | 5558 Views | Created by sqldeveloper2008 - Sunday, October 16, 2011 7:43 PM | Last reply by Arbi Baghdanian - Monday, October 17, 2011 8:08 PM -
0 Votes
SSAS Named Set Using [Dim Date].
In my date dimension I've got the both [Date] and [Start of week starting sun date].Answered | 2 Replies | 742 Views | Created by rockit - Tuesday, August 2, 2016 1:27 PM | Last reply by Just Karl - Wednesday, August 3, 2016 1:31 PM -
1 Votes
Date from plus 40 weeks
Need records that are 40 weeks old counting from DATE_FROMAnswered | 4 Replies | 908 Views | Created by MVP_88 - Monday, July 28, 2014 8:25 AM | Last reply by MVP_88 - Monday, July 28, 2014 9:12 AM -
0 Votes
determine Start week - Sunday, in TSQL
The 0 ('19000101') anchor date is Monday, that's why you're getting Monday as first date.Answered | 6 Replies | 6545 Views | Created by Ulka - Tuesday, May 3, 2011 7:09 PM | Last reply by Ulka - Wednesday, May 4, 2011 1:44 AM -
5 Votes
Converting date into work week
For the DATEPART function, wk or week, doesn't calculate week number according to the ISO standards and according to the most parts of the world.Answered | 6 Replies | 11041 Views | Created by אנה - Monday, June 25, 2012 7:54 AM | Last reply by TiborK - Monday, June 25, 2012 4:25 PM -
0 Votes
Start of current week
It is a really good idea to have one for many different types of date manipulation.Answered | 15 Replies | 3877 Views | Created by kuopaz - Friday, October 14, 2011 3:05 PM | Last reply by Tom Cooper - Friday, October 14, 2011 9:43 PM -
3 Votes
Getting the Date From Week Number
First, for your DateAdd() math, you need to derive a start date, which is usually the first day of the year.Answered | 7 Replies | 13984 Views | Created by rgoal - Sunday, October 7, 2007 8:13 PM | Last reply by Lisa Nicholls - Tuesday, October 9, 2007 4:29 PM -
0 Votes
How to build 7 day weeks based on start and end date?
= @s_date and dateAnswered | 6 Replies | 4036 Views | Created by BI_Quest - Friday, April 9, 2010 12:11 AM | Last reply by jimvern - Friday, April 9, 2010 8:02 AM -
0 Votes
last week and last 2 week date range
Hi, try this declare @d int set @d=(select datepart(dw,'2011-04-15')%7) select ...Answered | 3 Replies | 6303 Views | Created by Yazdani ISTS - Tuesday, April 12, 2011 7:07 AM | Last reply by Yazdani ISTS - Tuesday, April 12, 2011 9:08 AM -
3 Votes
from week number to date
You can also simplify the logic to use basic date math.Answered | 12 Replies | 3910 Views | Created by psycolor - Tuesday, July 13, 2010 12:10 PM | Last reply by Dave Ballantyne - Wednesday, July 14, 2010 2:01 PM -
0 Votes
How I select Start of week is Friday from date of Year ?
You can refer the expression which BH provided to calculate the actual start data and use it in the start date parameter of your dataset query.Answered | 2 Replies | 4600 Views | Created by Deshpande Parikshit - Thursday, September 9, 2010 9:32 AM | Last reply by Tony Chain - Tuesday, September 14, 2010 9:34 AM -
0 Votes
Find Start date and end date of every week of given month
Yes, that was a great help. i really need to work on the query that used to compare the week start date and end date comparison.Answered | 10 Replies | 11851 Views | Created by Sundarrajan Ganesan - Thursday, December 3, 2009 3:55 AM | Last reply by Sundarrajan Ganesan - Tuesday, December 15, 2009 3:02 AM - Items 1 to 20 of 1136966 Next ›
No announcements
