fyi
DECLARE @start AS INT= 20171215;
DECLARE @end AS INT= 20180119;
SELECT CONVERT( DATETIME, CONVERT(VARCHAR(8), @start));
SELECT CONVERT( DATETIME, CONVERT(VARCHAR(8), @end));
SELECT DATEDIFF(DAY, CONVERT( DATETIME, CONVERT(VARCHAR(8), @start)),CONVERT( DATETIME, CONVERT(VARCHAR(8), @end)))
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day