SQL Set Date Range

SQL set date variables and put them in a where clause

declare @DateFirst datetime = '20170815', @DateFinal datetime = '20341214'

— AND (@DateFirst Is Null OR @DateFirst < DATEVALUE)
— AND (@DateFinal Is Null OR @DateFinal < DATEVALUE)