Based on Gregorain calendar, every week of a year has a number from 1 to 52, 53 or 54. Use this tag for instance if you want to calculate the weeknumber from a certain date or vice versa. You also might include the date tag. This tag is independent of programming language.
Questions tagged [week-number]
603 questions
0
votes
2 answers
SSAS MDX datepart iso_week
In T-SQL I can retrieve ISO week number using dateprat function:
select datepart(iso_week, sysdatetime())
Is there an equivalent in MDX? I have troubles to find it.
I can retrieve number of week in MDX e.g. like this:
with member Measures.Test as…
Petr
- 15
- 1
- 5
0
votes
0 answers
SQL WEEK NUMBER
I am looking for a way to extract a week number based on this calendar:
http://www.timeanddate.com/calendar/custom.html?year=2014&country=1&wno=1&holm=1&df=1
so eg a date of '2014-12-28 00:00:00.000' should give me week 1 and not 53
SELECT DATEPART…
Kris
- 49
- 7
0
votes
2 answers
How To Get ISO-8601 GMT/UTC Week Number of Year
In Objective C, how do I take the GMT/UTC date and apply the ISO-8601 rule to get the week number?
PHP generates a week number of the year in ISO-8601 format when one uses the gmdate('W') statement. This, however, doesn't match in Objective C when…
Volomike
- 23,743
- 21
- 113
- 209
0
votes
1 answer
Is there any numeric week number format which define week in many years?
With PHP date functions, we can easily use a week number which change 0 to 53. This count starts from zero each year.
I'm looking for a date format which give me a numeric value which is continuing each year without count reset.
Example:
this_week =…
user1488895
- 71
- 3
0
votes
1 answer
Django: fullcalendar weeknumber
I try to display week numbers but nothing happens
I put weeknumber in the javascript file
$(document).ready(function() {
$('#calendar').fullCalendar({
weekNumbers: true,
height:400,
header: {
…
Patrice
- 209
- 1
- 4
- 15
0
votes
1 answer
Linq to SQL (Entity Framework) group by work Week number
In Linq to SQL is it possible to group by Week Number of Work week, not weeks from year, for example 1/1/2016 is in the same week of 12/31/2015 it is not the same week of the year (but it is in the same physical week if you will)
Yitzchok Neuhaus
- 26
- 5
0
votes
1 answer
VBA Macro WeekNum not defined
I'm trying to concancenate Year with WeekNum in VBA. But it said that the WeekNum Sub or Function does not defined.
How can I solve this? Here is my code :
For lrow = EndRow To 2 Step -1
CurrentSheet.Cells(lrow, "AC").Value = _
…
IlhamideaZ
- 103
- 10
0
votes
1 answer
missing missing values in range mysql
I have already asked a similar question, but I still don't seem to be able to get my head around it. I have a column device_create_date on my sql database
2015-07-14 12:35:19
2015-07-15 12:45:37
2015-07-15 12:45:37
2015-07-16 12:35:37
2015-08-14…
Nick Ko
- 435
- 4
- 16
0
votes
0 answers
Getting calendar week on a different way than with isocalendar
I'm having the following issue:
I have a function which iterates over a list of dates which are all workdays. For each auf these dates I need to get the week number. So this might look currently like:
last_day = datetime.date(2016, 2,…
Calanas
- 1
- 1
0
votes
1 answer
sql set the week number start
This statement gives me the number of the current week starting from the 1st of january
select datepart(week,getdate())
I would like the calculation to be done starting from 1st november.
Is there a way I can accomplish this? I know the date…
Abbaskhan6428
- 65
- 1
- 11
0
votes
1 answer
WeekOfYear -1 SQL HELPP?
select distinct
pos.DivNo
,WeekOfYear
,[ProductCode]
,sum(Quantity)[Quantity]
into #sales1
from cbis799p.dbo.pos pos
LEFT JOIN DataWarehouse.dbo.Calendar c on pos.PosDate = c.Datetime
Where pos.DivNo = 772 and ProductCode = '1020'
and WeekOfYear =…
James Chaggar
- 15
- 6
0
votes
1 answer
Weeks that overlap a year SQL
I'm currently working on a huge report and need some help on a vital part which I've been on for ironically weeks
I have a report that calculates quantity based on a few things
but what im trying to do is when the "PREQuantity" column is null and…
James Chaggar
- 15
- 6
0
votes
2 answers
MonthCalendar control displaying non ISO-8601 compliant week numbers
I am encountering an issue with the MonthCalendar Windows Form UI Control. With the ShowWeekNumbers property enabled, it shows week 1 of 2016 to be the week containing January 1st, which is on a Friday. This is not compliant with ISO-8601, which…
Esquire Fox
- 1
- 3
0
votes
2 answers
How to sum data group by week but sum from beginning?
I have a database like this :
Entry_No Week Registering_Date Bin_Code Item_No Quantity
=====================================================================
1 26 6/26/2015 BIN 1 A 10
2 26…
0
votes
1 answer
Epi-week method for JAVA
i need to get the epi-week of a given date,so it'd be very helpful if there is a method or api to achieve this for Java.
The definition for epi-week is the following "The first epi week of the year ends, by definition, on the first Saturday of…
