Sort today

Hello everyone !!
I have a little problem to solve.
I have an “ATTENDANCE” table where I enter the attendance of the employees on the day by means of a barcode.
The attendance table refers to the “appointments” table.
If in the appointments table there is a code associated with the employee, the data is saved on the “attendance” table by means of a barcode reader.
The problem is that since the appointments are for the whole month, when an employee books with QR CODE the scanner tells me that the id is already present.
How can I filter by today’s date?