Add between date and a specific date

Question

Hi,

In one of our feed I need to add between date and also a specific date

WHERE
sof.Sales_Office = @SalesOffice
and
s.postage = 'Y'
and
s.[Order Date] >= @FromDate and s.[Order Date] <= @ToDate

How would I say the above and s.[Order Date] = '02/06/2017'

Thanks for help.

Answer 1

If you want to get data for a specific date addtional to the date range, then it's a OR logic, not AND; don't forget the brackets =>

WHERE sof.Sales_Office = @SalesOffice
ands.postage = 'Y'
and (s.[Order Date] >= @FromDate and s.[Order Date] <= @ToDate 
     OR s.[Order Date] = '02/06/2017')