sri.chithu.selva (11/8/2012)
I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?
What defines a "week number" at your company? For example, are you usig ISO week numbers, SQL week numbers, or some form of special "fiscal week" numbers? Are the start and end dates also the start and end dates of a single full week, a partial week, or do they span multiple weeks?
In any case, the best bet here would probably be to build a "Calendar Table". You can find many examples and some usage examples by doing a web search on the term.
--Jeff Moden
Change is inevitable... Change for the better is not.