enter image description here

Show the Sales, Profit and ShipDate fields (only) of any records from the month of January (any year) where Region and Province are both Ontario.

  • 2
    What datatype is ShipDate?
    – Philᵀᴹ
    Feb 28, 2020 at 19:58

2 Answers 2


....... AND Month(Shipdate) = 1


Does your shipdate in invoice table contain a date or a month only. If it's a date then you need to define an expression (a new field in your query as expression Month (shipdate) and then put your WHERE criteria January in newly defined expression. Hope this helps.

Not the answer you're looking for? Browse other questions tagged or ask your own question.