Making Monday 1st day of the week

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: Sarah Barnes on 21-01-2013 05:26:09 AM
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