Has anyone out there been able to make Monday the 1st day of the week, on 8.5.4.
I am using the query , dateadd(week, datediff(week,0, ASGHH.DateTime), 0).
I have tred replacing the 1st 0 with a 1, and a -1 however none seem to work, when I have run the report the date shown shows the Monday, however, when runnign as a relative date report for last week, I had a return of Monday 14th January & Monday 21st January for a couple agent.
If anyone can help I would be grateful.
Cheers Sarah