How to count week number?

Question

How to count week number?

Vaghasiya Nilesh

SSChasing Mays

Points: 633
More actions
July 22, 2010 at 3:55 am

#235674

Date Format : (dd/mm/yyyy)
My week is strat from saturday to friday
and im enter Fromdate - 1/12/2010 and Todate - 21/7/2010 that giving me output will be current week number
onething im enter Fromdate - 1/12/2010 and Todate - 21/7/2010, so that not consider from 1/12/2010 - 6/12/2010(week) but it consider saturday to friday(week)
thank u..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

Vaghasiya Nilesh (7/22/2010)
...
and im enter Fromdate - 1/12/2010 and Todate - 21/7/2010 that giving me output will be current week number
...

Your question is not very clear.

To get number of weeks between to dfates you can use:

DATEDIFF(week, FromDate, ToDate)

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 2

What part of your question remains unanswered based on my post on the other thread covering the very same issue??

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]