SELECT DATEDIFF(d, GETDATE(), endDate) * 2 AS [Days times 2] FROM MyTable
DATEDIFF(day,endDate,currentDate) * 2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)