Link to home
Create AccountLog in
Avatar of Pdeters
Pdeters

asked on

Access 2003 Query - find all dates past due

I have an Access 2003 query that one field is a date. I want to pull only those records that are 10 days past due
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

past due from todays date?

select * from table
where [dateField]=dateadd("d",-10,Date())

or

select * from table
where [dateField]=Date()-10

ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
< Date()-10  will give all the dates before  Date()-10
not only those with 10 days past due.
Pdeters,
 you posted as your requirement is

I want to pull only those records that are 10 days past due