No announcements
Found 2770071 threads
-
1 VotesTable date format - How can I display Week 1, Week 2, instead of the date?
What you want to do with the date format in the table cannot be done.Answered | 6 Replies | 22861 Views | Created by CraigPH - Wednesday, December 1, 2010 9:57 PM | Last reply by Eli Robillard - Wednesday, July 30, 2014 8:33 PM
-
0 Votes
Week number from date
Good to have table for better control....Answered | 8 Replies | 5711 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
How To Show Week Numbers in DateTimePicker vb.net
You can use convertor to get a VB.Net version.Answered | 3 Replies | 11445 Views | Created by Madasamyponraj - Tuesday, November 27, 2012 10:23 AM | Last reply by Mark Liu-lxf - Wednesday, November 28, 2012 4:13 AM -
0 Votes
Week Wise Stored Procedure
I would build a calendar table with a ISO-8601 week-within-year format column in addition to the usual Common Era date.Answered | 8 Replies | 1696 Views | Created by Tech Aspirant - Friday, January 2, 2015 6:58 AM | Last reply by --CELKO-- - Tuesday, January 6, 2015 12:41 AM -
0 Votes
How to compare this week with last years week sales ?
DECLARE @thisYearThisWeekStart DATETIME = DATEADD(DAY,1-DATEPART(weekday,'2014-01-01'),DATEADD(WEEK,DATEPART(WEEK,GETDATE())-1,'2014-01-01')) DECLARE @thisYearThisWeekEnd ...Answered | 1 Replies | 1238 Views | Created by Developer life - Wednesday, July 9, 2014 9:47 PM | Last reply by Patrick Hurst - Wednesday, July 9, 2014 10:31 PM -
3 Votes
from week number to date
Personally , i prefer a calendar table.Answered | 12 Replies | 4025 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
Parallel Period and Week to date
No such level was found in the cube' How can i go round this?Answered | 8 Replies | 3667 Views | Created by Kennilove - Friday, November 18, 2011 9:16 AM | Last reply by Challen Fu - Friday, November 25, 2011 2:11 AM -
0 Votes
Calendar week - previous week , last year week
I would build a calendar table with a ISO-8601 week-within-year format column in addition to the usual Common Era date.Answered | 5 Replies | 3673 Views | Created by vamz9 - Wednesday, December 19, 2012 3:16 AM | Last reply by --CELKO-- - Thursday, December 20, 2012 3:08 AM -
6 Votes
Start week of the month for a given week
> I may store the first day of the week as a parameter.Answered | 33 Replies | 1483 Views | Created by Jamesit0 - Thursday, July 23, 2015 5:10 PM | Last reply by --CELKO-- - Friday, July 24, 2015 4:25 PM -
0 Votes
Week 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 | 800 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
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 | 7359 Views | Created by mike950 - Friday, April 17, 2009 2:08 PM | Last reply by Aaron Meyers - Tuesday, April 21, 2009 1:02 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 | 11425 Views | Created by אנה - Monday, June 25, 2012 7:54 AM | Last reply by TiborK - Monday, June 25, 2012 4:25 PM -
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 | 6466 Views | Created by Yazdani ISTS - Tuesday, April 12, 2011 7:07 AM | Last reply by Yazdani ISTS - Tuesday, April 12, 2011 9:08 AM -
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 | 3992 Views | Created by Ravishankar Polepalli - Friday, April 20, 2012 2:00 AM | Last reply by Ravishankar Polepalli - Saturday, April 21, 2012 2:31 AM -
0 Votes
how to get Week of year (i.e. week number) of a give date in windows store app
Hi, can anyone tell how to get week of year i.e. week number of any given date in windows store app?Answered | 2 Replies | 2016 Views | Created by MAbdul - Thursday, July 25, 2013 9:39 PM | Last reply by MAbdul - Friday, July 26, 2013 8:03 AM -
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 | 7888 Views | Created by Abhijeet Kamble - Tuesday, August 19, 2008 1:39 PM | Last reply by Anilred - Tuesday, August 19, 2008 3:53 PM -
0 Votes
How to get the weeks according to dates in a expression?
The SQL Server DATEPART function will return the Week of the Year.Answered | 7 Replies | 1109 Views | Created by Rasulchowdary - Tuesday, July 29, 2014 11:48 AM | Last reply by Chris Utter at Neudesic - Tuesday, July 29, 2014 10:21 PM -
1 Votes
Get Start date and week End date for particular Week number and year
How to modify this for example if we just give Week number as parameter then how to find startDate and endDate ??Answered | 13 Replies | 20553 Views | Created by sunDAC - Wednesday, April 1, 2009 10:49 AM | Last reply by NicoJuicy - Wednesday, January 9, 2013 7:47 AM -
4 Votes
Generete Count of Sales Week by Week
may be this will help ...Answered | 8 Replies | 1489 Views | Created by Joe Marx's - Friday, January 31, 2014 8:57 PM | Last reply by Joe Marx's - Monday, February 3, 2014 2:17 AM -
0 Votes
how to generate alert on week before a specific date
Assuming you use some kind of database - create a job that will run daily and collect all the alerts (product expiry) into some alert table.Answered | 2 Replies | 2995 Views | Created by Golden Zero - Thursday, November 11, 2010 1:51 PM | Last reply by DeniskaB - Thursday, November 11, 2010 2:07 PM - Items 1 to 20 of 2770071 Next ›
No announcements
