Increment week function starts on Sunday

[dibbo]

Hi, i've got the following code in a query:

DATEADD(wk, DATEDIFF(wk, 0, SH_StartDateTime), 0)

it works ok in the way that it returns:
08/11/2004
08/11/2004
08/11/2004
15/11/2004
15/11/2004
15/11/2004
22/11/2004
and so on....
The 8th, 15th and 22nd being Monday's

But for some reason it's including all SH_StartDateTime from the day before aswell i.e. Sunday.
so the actual data grouping is Sun-Sat instead of Mon-Sun

Any ideas on how to solve this?

Many Thanks

David

 

[dibbo]

sorted..

replaced SH_StartDateTime with DATEADD(d,-1,SH_StartDateTime)

 

[donutman]

[Blue]SET[/Blue] [Black]DateFirst[/Black] 1
[Blue]SELECT[/Blue] [Fuchsia]DateAdd[/Fuchsia][Gray]([/Gray]wk[Gray],[/Gray] [Fuchsia]DateDiff[/Fuchsia][Gray]([/Gray]wk[Gray],[/Gray] 0[Gray],[/Gray] SH_StartDateTime[Gray])[/Gray][Gray],[/Gray] 0[Gray])[/Gray]

-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]