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

Week Number

Status
Not open for further replies.
PauloMongo

PauloMongo

Programmer
Jul 16, 2001
80
GB
Is there any function that will return to me the week number of the current year, eg 1 to 52
 
Sort by date Sort by votes
DatePart ("ww", DateTimeField) is what you are looking for Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
449
socalvelo
socalvelo
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
306
socalvelo
socalvelo
Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
588
Brian S
Brian S
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
527
lbass
lbass
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
716
LauraW
LauraW

Part and Inventory Search

Sponsor

Back
Top