mssql
declare @FromDate date = GETDATE()-2 declare @ToDate date = GETDATE()-100 dateadd(day, rand(checksum(newid())) * (1 + datediff(day, @FromDate, @ToDate)), @FromDate)