SELECT * FROM Sample WHERE DATEDIFF(DAY, StartDate, GETDATE()) = 15
select * from Sample where datediff(d,StartDate,getdate())=15
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)