Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sunday Date...need the 1-52 week number

Status
Not open for further replies.
toolsofministry

toolsofministry

Programmer
Sep 11, 2002
24
US
I have an application where the user clicks a Sunday on a calendar. Is there an automatic way that the corresponding week number for that Sunday can be displayed. In other words the fourth Sunday in January would be week 4 ETC.

Thanks and Merry Christmas if you are like me, a computer holic and cannot leave it off for one day.

If so, Happy New Year.
 
Sort by date Sort by votes

Check out the DatePart function with the "ww" for the interval with the firstdayofweek and firstweekofyear set to what you want.

Good Luck

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
SORT msflexgrid column 1 with decimal number 1
Replies
4
Views
600
2009luca
2009luca
sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
303
sal21
sal21
sal21
  • Locked
  • Question
I can't find the routine to download the image file anymore
Replies
1
Views
262
strongm
strongm
sal21
  • Locked
  • Question
Check if mobile number exists, with Api rest or other service. Possibile? 1
Replies
2
Views
506
sal21
sal21
sal21
  • Locked
  • Question
Strongm.... only for you - check if the customer have riceved the email 1
Replies
2
Views
433
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top