DateDiff
SELECT DATEDIFF(day,date1,date2') AS DiffDate
select DATEDIFF(day,date1,date2) as dDiff from table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)