Untitled

t-sql conditional date processing
WHERE
    (@argstart IS NULL AND @argend IS NULL)
OR  (@argend IS NULL AND create_date > @Argstart)
OR  (@argstart IS NULL AND create_date < @argend)
OR  (Createdate BETWEEN @Argstart AND @Argend)

where (create_date >= @arg_start or @arg_start is null) and
      (create_date <= @arg_end or @arg_end is null)

CREATE PROC usp_report
    @StartDate datetime = '1900-01-01',
    @EndDate datetime = '9999-12-31'

AS

SELECT *
FROM MyTable
WHERE DateField BETWEEN @Startdate AND @EndDate