Track a Value 15 yrs from todays date

H

HelloWorld

I have field in a database that contains a date for a DUI conviction - i need
a criteria that compares that date and todays date and sees if it is more
than 15 years apart . Any help .. for syntax help the field name is
Applicant Data.Conviction_DUI_Date and it is a date/time field.

Thank you

Steve
 
O

OfficeDev18 via AccessMonster.com

If Date() > (DateAdd("yyyy",15,ApplicantData.Conviction_DUI_Date) Then
Something...
End If

I don't quite understand the period usage instead of the bang ('!'), but if
that's what works...

HTH
 
H

HelloWorld

Hey Man.

I was trying to see how this could work in a query and I dont think Queries
accept VB statements and if they do - it is way beyond me as how to make it
work ... thanx for the help though ... you and tina have both helped to make
the world less muddy.

Steve
 
Top