In Excel I use:
WHERE
(YEAR(DayTotals.SCADADate)=?)AND
(MONTH(DayTotals.SCADADate)=?)
ORDER BY DayTotals.SCADADate
to ask report user to enter report YEAR and MONTH for a Monthly report
Is this possible in LibreOffice ?
Gene
You should upload a document here to understand it. Edit your question and upload your anonymized document. Alternatively, install LO and test it yourself.
That’s an SQL query, wherever you use that in Excel.