Date Age

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
 
A

Alex H

Thanks, but that actually doesn't seem to work for some reason, no records
are being selected

A
 
A

Alex H

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

Alex
 
V

Van T. Dinh

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

You're welcome ... Glad to help ...
 
Top