Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jarxt8
Starting Member
2 Posts |
 Posted - 2008-10-14 : 15:41:07
|
| I have a pretty quick question. is there a way to change the starting day of the week from sunday to monday in reporting services? i have a report that is grouped by week and the people im creating the report for collect their data daily and also weekly. the problem is that the weekly values are on sunday and when i perform an aggregate function on that sunday it doesnt include the previous week because it isnt contained in that grouping. any help i could get with this would be greatly appreciated. |
|
|
jarxt8
Starting Member
2 Posts |
Posted - 2008-10-14 : 17:14:25
|
| Ok, new question. I'm trying to use this datepart function but when i use it to find the date interval "ww" and i provide it with a first day of the week it always says "Overload resolution failed because no accessible 'DatePart' can be called without a narrowing conversion." my expression is as follows :=datepart("ww", today(), 2)this should give me the week number of today with the first day of the week being monday right? ive tried multiple configurations of this expression and it always says the same thing. wheres my conversion at? is there a format of the date that won't pass with a firstdayofweek value? i haven't gotten this parameter to work even once, its becoming really frustrating. any help with this would be much appreciated. |
 |
|
|
aponduri
Starting Member
1 Post |
Posted - 2008-10-23 : 21:07:06
|
| Try using SET DATEFIRST { number | @number_var }.Hope this helps |
|
|
|
|
|
|
Changing the starting day of the week