• thanks! so it's DATEPART(dw,'date')