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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing Week number by date

Status
Not open for further replies.
blackcat9000

blackcat9000

Programmer
Feb 25, 2003
15
0
0
GB
I want to show the week number when i enter a particular date. i.e 23/02/2003 = week 9.

Can anyone help?

 
Sort by date Sort by votes
Blackcat:

See the following thread:

thread702-459900

HTH,

Vic
 
Upvote 0 Downvote
Thanks for that Vic.

That worked great.

Your the man.

Blackcat9000



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
409
serino
serino
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
236
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
220
JimStrand
JimStrand
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
230
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
108
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top