Problem with date fromat in access 1

[numbered]

I have this in my database jobs

jobs_id type start_date end_date
10 management 02/10/2002 11/10/2002

SELECT *
FROM jobs
WHERE type = 'management'
AND (day(start_date) & month(start_date) & year(start_date)) <= (day(now()) & month(now()) & year(now()))
AND (day(end_date) & month(end_date) & year(end_date)) >= (day(now()) & month(now()) & year(now()))

It returns 0 records. Why am I not getting that record?

 

[nsukari]

This may seem simplistic, but it will work

SELECT *
FROM jobs
WHERE type = 'management'
AND [start_date] < now()+1
AND [end_date]> now()-1

 

[numbered]

That worked.

Thank you very much!!