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.![[hairpull3] [hairpull3] [hairpull3]](/data/assets/smilies/hairpull3.gif)
Thanks.
![[machinegun] [machinegun] [machinegun]](/data/assets/smilies/machinegun.gif)
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.
![[hairpull3] [hairpull3] [hairpull3]](/data/assets/smilies/hairpull3.gif)
Thanks.