Date Age

  • Thread starter Thread starter Alex H
  • Start date Start date
A

Alex H

Hi, I have a date field and I want to select all records where the date
field is over 30 years - could some kind person help me with the correct
dyntax please?

Tks
A
 
Use the criterion:

.... WHERE [DateField] < DateAdd("yyyy", -36, Date())
 
Thanks, but that actually doesn't seem to work for some reason, no records
are being selected

A
 
Sorry, of course it works - needed to get my less than and greater than
signs sorted... DUH Sorry and thanks for your help

Alex
 
No worries. You obviously picked up that I mistyped 36 instead of 30 so we
all made mistakes.

You're welcome ... Glad to help ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping quarters 3
Grouping on a date field 2
making age group query work 7
age groups 6
Calculated age field not populating after 1/1/09 1
Calculate an "Age Group" from age in years 10
Access Dcount function in access 0
Date Difference limited to 100 years 6

Back
Top