OK, this is probably an FAQ but…
I need to run a query that extracts data for the previous calender month from a Libreoffice DB. Something like a ‘SELECT * from Table BETWEEN startofmonth and endofMonth’ …type…thing.
Simple. Except I cannot find the answer. I’ve been hunting all morning and nothing works in LO!
I need this to at least partly automate invoicing for my clients. I cannot keep up with everything by manual typing anymore!
It’s been many years since I have used SQL at all and it was returning results by CLI for test purposes while this has to go to a formatted report. I am not in tech any more so need a little nudge here! My clients are repeat every month so I do not need pretty one off invoices. I need “Who came when - report - send.”
Thanks in advance. This is all I need to halve my paperwork load.
[Oh, running LO 6.0 under Linux KDE Neon if that helps. I guess I can PPA if it will help.]