Q&A for professional and enthusiast programmers
declare @dt1 as date; set @dt1 = '2024-01-11'; declare @dt2 as date; set @dt2 = '2023-08-07'; select DATEDIFF (day, @dt2 , @dt1 );