Dates query

[Radion]

Hi there,

I'm making a database for a small library collection. I want to make a query for all overdue books, so if the Date which the book is due has passed, it will come up in the query. What do I put beneath the 'Date due' field?

So If 1 day has passed that date, it will be overdue.

Thanks for any help.

 

[gemma-the-husky]

< date()
ie the date due back is before today's date

i assume you exclude completed lendings/returned books somehow, otherwise you will get all of them also!

 

[Radion]

Yeah, I have another (yes/no) field, to be selected once the books have been returned. Thanks for that! Much appreciated!

 

[rhett7660]

gemma-the-husky

Thank you that is what I was looking for!