Creating reports based on date on LO Base

[samuel_ribeiro]

Version: 7.5.7.1 (X86_64) / LibreOffice Community
Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR
Calc: threaded

Sup, I’m using LO Base for quite a while to build a project for storing owners and cars data, now I’m creating some new reports. My problem is that I need to find a way to create a report based on the date the cars entered the parking yard, because I need the report to list all the cars that currently are in the yard. So a way would be like to get all the cars that dont have the date they left, because that would mean that theyre still in the yard. Idk if it makes sense or if theres a way to do it, but its the problem im having rn.

[RobertG]

Might be a simple SQL-Code:

SELECT * FROM "tbl_Parking" WHERE "Date_left" IS NULL

Could also be included as Filter in the report, but will be easier to create the code in a query.

[samuel_ribeiro]

yeah it was pretty simple, thanks