Here is a nice tip from Itzik Ben Gan's "Inside Microsoft SQL Server 2005— T-SQL Programming" - January 1st 1900 as a Monday. So this will return all the records created on a Tuesday:

SELECT RecordID FROM Table

WHERE DATEDIFF(day, '19000102', RecordDate) % 7 = 0