DATEDIFF ( datepart , startdate , enddate ) -- example: SELECT DATEDIFF(day, '2036-03-01', '2036-02-28'); -- Returns -2