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
Excel Fiscal Week Calculator
I've been working on solving this for a few hours now and keep hitting a wall. I am very close but having small detail errors. Currently I am using =weeknum in excel vba to dynamically create a row and receiving a #NUM! error. It seems to work…
Tyler
- 39
- 7
0
votes
5 answers
Find out date of nth week's monday in PHP?
I have a simple situation where I have a user supplied week number X, and I need to find out that week's monday's date (e.g. 12 December). How would I achieve this? I know year and week.
Tower
- 98,741
- 129
- 357
- 507
0
votes
1 answer
DateTime: Converting 'yW' to earliest and latest possible dates, then BACK TO 'yW'?
The Issue:
We have some products which use a "YYWW" (date('yW')) format to identify date of creation.
Sometimes we don't even get the week .. all we have to work with is the year value.
I am currently using DateTime->setISODate() to get dates out…
mOrloff
- 2,547
- 4
- 29
- 48
0
votes
1 answer
Weekly Dropdown Javascript
So basically, I need a dropdown to be generated with date ranges for the list of weeks between two years. So, for example, if the years are 2012 and 2014, it'll generate a list of weeks such as:
1/1/12-1/7/12
1/8/12-1/14/12
etc.
Going on until the…
user798080
0
votes
2 answers
Excel weeknum conditional average
Date Number Weeknum
4-Jan-96 0.094288 2
5-Jan-96 0.092872 2
8-Jan-96 0.090431 2
9-Jan-96 0.153586 2
10-Jan-96 0.029758 3
11-Jan-96 0.052083 3
12-Jan-96 0.042797 3
15-Jan-96 0.047949 3
16-Jan-96 0.053029 3
17-Jan-96…
BigChief
- 1,413
- 4
- 24
- 37
0
votes
4 answers
How can I find the week which a day belongs to using javascript?
I want to find the number of the week which a day belongs to in javascript. My definition of week is the number of saturdays there have been up to that date. So the first few days of january are counted as the final week of the previous year. From…
Eric
- 95,302
- 53
- 242
- 374
0
votes
1 answer
Getting Dates from Week Numbers - Year Starts from March - Week 1 = March 1st week - PHP
I am trying to write a custom function for getting dates from week numbers but the requirement is that the week numbers are custom i.e. the week1 starts from 1st Week of March and the First Day of each week is Friday
I trying to do this in PHP.
Your…
vin
- 3
- 1
0
votes
3 answers
Getting the right week number of year
I want to get the right week number.
Using the to_char function, the function enumerate the week starting with mondey, but i want to get the week number considering that a week start on saturday.
Here is an example:
SELECT…
Houari
- 5,326
- 3
- 31
- 54
0
votes
3 answers
MySQL Select Week Range From Database
In my database I am storing week numbers and the relating years. For example something like this:
id | week | year | text
---+------+------+-----------
1 | 23 | 2012 | hello
2 | 27 | 2012 | something
3 | 39 | 2012 | more text
4 | 43 |…
Sean
- 269
- 1
- 6
- 16
0
votes
3 answers
Weeknumber print date out
Hallo all.
if i have week number 42 and i need to know what dates there are in this week, can sombardy maby tell me a easy way to get this info?
tanks a lot :)
ParisNakitaKejser
- 12,112
- 9
- 46
- 66
0
votes
2 answers
look up this week number?
I know how to look up this week number:
(SELECT DATEPART(wk, GETDATE()))
I need to know the syntax of getting the week number compare to another table:
SYNTAX:
SELECT THISWEEK -- WEEK NUMBER DATA
FROM dbo.DATETABLE
WHERE THISWEEK =…
Yves
- 12,059
- 15
- 53
- 57
0
votes
3 answers
Rails array with weeks and year
I want to list all weeknumbers together with year.
This is what I have:
start # 2012-05-10
ende # 2013-06-20
while start < ende
weeks << start.cweek
start += 1.week
end
List all weeknumbers:
@kws.each do |w|
w
end
I need some…
Werner
- 81
- 2
- 10
0
votes
3 answers
Get week of date from linq query
I am trying to get the week of a date from the database and compare it to a user selected value from a DateTimePicker. My users can select a day and I wrote a class that gives me the week of that day in the form 1 to 52. I am trying to select get…
yveslebeau
- 104
- 2
- 11
0
votes
1 answer
How can I update an application badge every week?
How can I update my application badge every week in background mode.
I am working on a app for week numbers, and my application badge are then current week number, so I want it to updating every week by it self.
How can I do that, I have searched…
Kasper Basse
- 21
- 1
- 4
0
votes
1 answer
How to make the countdown to every friday in the month?
I have a countdown at my site, i want it to countdown to next Friday, and when the friday is over, i want it to automatically countdown to the next Friday.. and just repeat that..
I have this script, but cant seem to get it to work, can some one…
Patrick R
- 1,949
- 3
- 32
- 58