No announcements
Found 1939424 threads
-
0 VotesGet week ending date based on work date and week ending day number
Another approach using set-based logic, quite easy to understand and almost impossible to forget: DECLARE @WorkDate DATETIME = '20121002', @WeekEndDay int = ...Answered | 2 Replies | 2720 Views | Created by ps0118mj - Tuesday, October 2, 2012 7:09 PM | Last reply by RichardTheKiwi - Wednesday, October 3, 2012 10:03 AM
-
0 Votes
Week Start Date and End Date
Declare @currentDate datetime = getdate(); Select @currentDate , dateadd(day, -datediff(day, 0, @currentDate) % 7, @currentDate) , ...Answered | 6 Replies | 914 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
Come up with a Startdate in the week and a end Date in the Week
I need to run another script after the 20th of the month that will grab the 1st day of the Month and create Startday and End Day upto ...Answered | 5 Replies | 697 Views | Created by JeffC72 - Wednesday, June 15, 2016 4:06 PM | Last reply by JeffC72 - Wednesday, June 22, 2016 2:03 PM -
0 Votes
How to build 7 day weeks based on start and end date?
= @s_date and dateAnswered | 6 Replies | 4176 Views | Created by BI_Quest - Friday, April 9, 2010 12:11 AM | Last reply by jimvern - Friday, April 9, 2010 8:02 AM -
1 Votes
Start and End date of a Given week of a Month
This format is 'yyyyWww-d' where yyyy is the year, W is as separator token, ww is (01-53) week number and d is (1-7) day of the week.Answered | 13 Replies | 2260 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
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 to Sunday...Answered | 8 Replies | 5793 Views | Created by sqldeveloper2008 - Sunday, October 16, 2011 7:43 PM | Last reply by Arbi Baghdanian - Monday, October 17, 2011 8:08 PM -
9 Votes
calculate number of months,weeks,days for two dates
I am working on this .Answered | 23 Replies | 11951 Views | Created by JR1811 - Wednesday, August 15, 2012 6:02 PM | Last reply by JR1811 - Thursday, August 16, 2012 9:04 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 | 14557 Views | Created by rgoal - Sunday, October 7, 2007 8:13 PM | Last reply by Lisa Nicholls - Tuesday, October 9, 2007 4:29 PM -
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 | 11529 Views | Created by אנה - Monday, June 25, 2012 7:54 AM | Last reply by TiborK - Monday, June 25, 2012 4:25 PM -
0 Votes
PowerShell: Get Date based on Week Number of Year...
This was also posted in ITCG and was answered there:Answered | 2 Replies | 1542 Views | Created by BenGiacaman - Saturday, March 19, 2016 11:50 PM | Last reply by Mike Laughlin - Monday, March 21, 2016 12:44 PM -
3 Votes
Reduce Working Days by Emp Start and End Dates
BUt yes, running total would calculate and sum the number of working days per resource to be used when determining capacity of subgroups, groups, divisions, etc.Answered | 5 Replies | 1191 Views | Created by Dennis DeRobertis for Expression Extras - Thursday, March 12, 2015 8:04 PM | Last reply by Gerhard Brueckl - Thursday, March 19, 2015 10:16 AM -
3 Votes
from week number to date
You can also simplify the logic to use basic date math.Answered | 12 Replies | 4108 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
Need to get week day & dates for a give year?
It might not be an issue for you, but keep in mind that in countries where the first day in the week is Monday, then week 1 starts on 2/1 2012.Answered | 7 Replies | 2063 Views | Created by Jaineera Naveen - Wednesday, September 5, 2012 10:51 AM | Last reply by Steen Schlüter Persson - DK - Wednesday, September 5, 2012 12:51 PM -
0 Votes
how to find week end date if i pass a week no in sql?
Hi how to find week end date if i pass a week no in sql?Answered | 1 Replies | 7918 Views | Created by Abhijeet Kamble - Tuesday, August 19, 2008 1:39 PM | Last reply by Anilred - Tuesday, August 19, 2008 3:53 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 | 3866 Views | Created by RajeshBodduluri - Tuesday, September 25, 2012 5:15 AM | Last reply by Dhaval Chauhan - Saturday, September 29, 2012 4:22 AM -
2 Votes
difference between two dates as number of weeks and days
DateDiff function has the first parameter that tells what kind of difference you want - in days, in weeks, etc.Answered | 4 Replies | 16921 Views | Created by Kiwi_wizz - Thursday, May 19, 2011 10:10 PM | Last reply by Naomi N - Friday, May 20, 2011 3:44 AM -
0 Votes
ssrs dropdown parameter with Week startDate and end date so that user selects only week and report shows the week details
http://hardik-bhavsar.blogspot.com/2011/03/default-values-for-date-parameters-in.htmlAnswered | 3 Replies | 6921 Views | Created by abcv - Tuesday, November 2, 2010 2:37 PM | Last reply by Hardik Bhavsar - Thursday, March 3, 2011 10:53 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 ...Answered | 6 Replies | 7518 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
Get begin and end date based on weeknumber and year
I'm not fully clued up on weeks of the year (whether week 1 starts on the first monday of the year / can it be the last monday of the previous year?)Answered | 3 Replies | 5187 Views | Created by VSempoux - Friday, January 23, 2009 9:40 AM | Last reply by gvee - Friday, January 23, 2009 11:08 AM - Items 1 to 20 of 1939424 Next ›
No announcements
