Problem attempting to recreate Date function from MS Access to SQL

[Jacque]

I'm using SQL Server 2008
MS Access 2007

Here is the piece of the MS Access query that I'm trying to recreate, I know enough MS Access to fill a thimble but Dateserial has me stumped. :-(

DateDiff("ww",Dateserial((Year(table.Date-6),(((((Month(Table.Date-6)-1)/3)+1)-1)*3)+1,1),table.Date-6) AS Week


Any help would be appreciated.
Thanks.

 

[sparkbyte]

Check this thread

thread183-65034


Thanks

John Fuhrman