Random Date Generator

SELECT DATEADD(day, DATEDIFF(day, 0, GETDATE()) - 1 - FLOOR(RAND(CAST(NEWID() AS binary(4))) * 365.25 * 10), 0)

Number 10 is the year range, for example, if you want dates from recent to 10 years before, select 10.