Making Monday 1st day of the week

Version 1
    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