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
 
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 ...
 
Back
Top