Supply Date based on DOW

Converting from vb to SQL: Below is my orginal logic:

Select Case Weekday(Date, vbSunday)
Case Is = 1
' We are at a Sunday so we need to go
' to previous Thursday

txtStartDate = DateAdd("d", -3, Date)
Case Is = 2
' We are at a Monday so we need to go
' to previous Thursday

txtStartDate = DateAdd("d", -4, Date)
Case Is = 3
' We are at a Tuesday so we need to go
' to previous Thursday

txtStartDate = DateAdd("d", -5, Date)
Case Is = 4
' We are at a Wednesday so we need to go
' to previous Tuesday

txtStartDate = DateAdd("d", -1, Date)
Case Is = 5
' We are at a Thursday so we need to go
' to previous Tuesday

txtStartDate = DateAdd("d", -2, Date)
Case Is = 6
' We are at a Friday so we need to go
' to previous Tuesday

txtStartDate = DateAdd("d", -3, Date)
Case Is = 7
' We are at a Saturday so we need to go
' to previous Thursday

txtStartDate = DateAdd("d", -2, Date)
Case Else
txtStartDate = Date
End Select

Logic is Saturday - Tuesday (Date=Previous Thursday, Otherwise Date=Previous Tuesday

So today (27/12/2005) Date = 27/22/2005.

Any suggestions??

Thanks,
CT Received on Tue Dec 27 2005 - 14:10:40 CST