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

calculate week from year in report builder

Status
Not open for further replies.
mjd3000

mjd3000

Programmer
Apr 11, 2009
136
GB
How do I take a datetime field in report builder and write an expression to get the week of the year?
 
Sort by date Sort by votes
I'd use the DatePart function

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
791
PeterDimitrov
PeterDimitrov
dawnanne
  • Question
Loop through rows in an SSRS table
Replies
0
Views
99
dawnanne
dawnanne
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
659
Theresajn
Theresajn
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
681
nomi_ssrs
nomi_ssrs
Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
716
Tom_2023
Tom_2023

Part and Inventory Search

Sponsor

Back
Top