It’s inside query editor. You will see the table I have choosen and only tow fields: ID1 and ReadDate.
You could write the conditions also directly in one column of "ReadDate:
<2000-01-01
>2025-12-31
IS NULL
Ok, but what is IST LEER
Regarding conditions in one column of ‘ReadDate’, do you mean like to put a year and month in a new querry or use an existing one, in the ‘Criterion’ section
Robert is using a german setup, so query editor shows german localisation. If you use SQL it stays in english.
So IST LEER is the same as IS NULL
Thanks , but I wonder if he has created a new query because mine are just using all the fields from the table.
Don’t wonder, just read:
And even if you wont believe the text, the photo of the query-editor shows he did.
Ah ok, Doh!
What next please?
Show a screenshot with opened listbox as you see in my screenshot - showing the months right way here with LO 25.2.0.3
I can’t take a screenshot of the opened listbox because it closes as soon as I lick on ‘take screenshot’
This one is all I can do, for now?
Screenshots of a opened listbox: Open listbox by mouse and click “Print” on the keyboard - works here without any problem.
But I see: You could now enter 2025-01 in LO 25.2.0.3, right? What’s the first entry in the listbox? Could you choose also 2025-02? Then it should work as expected.
I have tried and better tried to get a screenshot with the listbox open, and when I open the listbox and press prt scr, or alt prt scr or ctl prt scr, the listbox closes before a picture is taken.
I am using Linux Mint 21.3 Cinnamon with an oldish cherry keyboard.
Intel© Xeon© W-2133 CPU @ 3.60GHz × 6 CPU
15.6 Gb ram
NVIDIA Corporation GM107GL [Quadro K620 ] Graphics Card
X11 Display server
I’m using OpenSUSE 15.6 64bit rpm Linux with KDE. Screenshot-app here is “Spectacle”. I could set many different behaviors there. Open listboxes are shown by default.
But: Could you choose 2025-02 now with LibreOffice 25.2.0.3?
No, sorry I can’t choose 2025-02, because it is not listed. It only show as far as 2025-01 in LO 25.1
The only way I am going to get it listed is to manually add the dates myself.
Thanks