About access

Question

how to create a query that show bills have day before 365 days of computer

Answer 1

I'm pretty sure this should work.
SELECT * from bills where bill_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);

Answer 2

Access? Are you talking about Microsoft Access?

Answer 3

In which format are the dates stored?

Answer 4

No problem :)

Answer 5

yes, sir

Answer 6

ah, ok, thank you very much 😊