Please read query below. This query will show from 2017-12-01 to today 2018-02-27 result, now I only want to see one month result. Any good way to do it? For exemple: I would like to show FROM 2017-12-01 to 2018-01-01 2018-01-01 to 2018-02-01 and 2018-02-01 to 2018-02-27
@SendoutMonth date = '2017-12-01'
H.DoElectronicInvoice = 1
AND H.DateInvoice >= @SendoutMonth