|
I have a query that counts member's wedding dates in the database...
Select Sum(NumberOfBrides) As [Wedding Count], DATEPART( wk, WeddingDate) as [Week Number], DATEPART( year, WeddingDate) as [Year] FROM MemberWeddingDates Group By DATEPART( year, WeddingDate...
Started by digiguru on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
DATEADD(dd.
You can find the day of week and do a date add on days to get the start and end dates..
|
|
I need to calculate the date of the first day in a calendar week given a year/week, e.g.
Week 53 in 2009 -> Mon, 28.12.2009
Week 1 in 2010 -> Mon, 04.01.2010
How would you wirte that code?
PS: In the Gregorian calendar the first week of a year is...
Started by Thomas Jespersen on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Duplicate?
http://stackoverflow.com/questions/662379/calculate-date-from-week.
For the example.
|
|
Given a week number, e.g. date -u +%W , how do you calculate the days in that week starting from Monday?
Example rfc-3339 output for week 40:
2008-10-06 2008-10-07 2008-10-08 2008-10-09 2008-10-10 2008-10-11 2008-10-12
Started by hendry on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
It includes example code in 'C'
PHP
$week_number = 40; $year = 2008; for($day=1; $day<=7; $day++) { echo date('m/d/Y', strtotime($year."W".$week, but will get the dates in a week....
This page has information which may be helpful.
|
Ask your Facebook Friends
|
I need to be able to create recurring events that happen on specific days but don't necessarily happen every week. They could be scheduled bi-weekly, every 3 weeks, etc. There is a current implementation that needs an update and I'd like to use the temporal...
Started by Jeff Whitmire on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I've got....
If this is a scheduling application have you looked at: http://icalendar.rubyforge.org/ I've decided to build what I needed into runt .
You aren't clear, are you running a script continiously to do this? If so why not use something like "at" .
|
|
I am implementing a contest system in which the user has to choose the correct answer of multiple questions. Each week, there is a new set of questions. I am trying to find the correct way to store the user participations in a database. Right now I have...
Started by Antoine Aubry on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Do you really need to associate a participation with its week? You can get it through Question
So:
Answer(Id,UserId,QuestionId,Value) Question(Id,WeekId,Text) Week(Id, StartDate) Personally I think is keyed with the user and the week....
|
|
What i am trying to do is to get NSDate today, yesterday, this Week, last Week, this Month, last Month variables ready for comparison for headers to be added on UITableView's titleForHeaderInSection
what i want is done manually in the code below for date...
Started by Hasnat on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
To a previous day, the start of a week, the start of a month, get the day of a week, the day of a month...
|
|
Fazers 2012 52 Challenge - Week 3 "Sigh" Week 4 'Sweet' added Must be absolutely mad to try this as my photography time is limited. I am a carer for most of the week. Will have a bash though, but may not be able to keep up the weekly schedule. :bonk:...
Started by fazer on
, 30 posts
by 18 people.
Answer Snippets (Read the full thread at talkphotography):
Good Luck for next week ....
Hopefully week 1 'Direction'
Inspired by having that's the first one posted, looking forward to week 2 I like the crazy angle :) i like the way you.
Thats my first challenge lol.
With posting from Flickr.
|
|
52 Weeks With Wookee *Week 2 added
Thought I'd give this a go this year to try and improve, to think a bit more about what I'm doing and to get a variety of subjects. I don't think I'll give myself any jokers as I want to see how much I do improve (or...
Started by Wookee on
, 12 posts
by 9 people.
Answer Snippets (Read the full thread at talkphotography):
Interesting reflections and hope to use this to help improve things.:thinking: This week's offering for "Fear"
http.
Cheers.
Week 2 will be up shortly...
Well, week 1 done so well done.
|
|
The Oakster's 52 Week Challenge - Week 2 added!!
Well here goes.... :Gulp:
I am completely new to photography so I'm hoping to see some improvement over the year :D
Week 1 : Direction - (Original Shots) - (Suggested Edits Version)
Week 2 : Fear - (Original...
Started by The_Oakster on
, 21 posts
by 15 people.
Answer Snippets (Read the full thread at talkphotography):
Just in time for week 2 :D I prefer to squeeze these edits in before ....
;) Good luck Ben get your thinking cap on Week 1 ;)
A revisit is planned though it won't be until Saturday morning.
Good luck with it :thumbs: Good luck with it Ben .
|
|
SteveH40 - 2012 - 52 Week Challenge - Week 2 -Fear - Added Oooo this all seem's quite daunting now :)
Hey, if it turns out a bit pap, I will have had fun trying :)
Enjoy.
Week 1 : Direction - http://www.talkphotography.co.uk/for...42&postcount=4
Week...
Started by SteveH40 on
, 18 posts
by 10 people.
Answer Snippets (Read the full thread at talkphotography):
Good job Thanks all, week....
Week 2 - Fear -
http://farm8.staticflickr.com/7027/6...9587ee21_b.jpg
p7100 009 thinks.
For you :-) Going to try and get week 2 up today / tomorrow, been a b'stard of a week at work and not had time.
|
