• Painful dealing with dates stored as strings..

    You'll have to use the same method as the YEAR query.

    SELECT *

    FROM tbl

    WHERE CAST(SUBSTRING([myDateString], 1, 10) AS DATETIME) >= DATEADD(d, -3, getdate());