DOB query

[rvd48]

i would like to list all people if they are under 35, i thought it would be "=now()-35" but it isnt, anyhelp please?

 

[The_Doc_Man]

Yeah, you got caught on a technicality. Date units are DAYS, not years.

You could try something like a DateDiff (which you need to look up in the help files) where you take the difference between the DOB and Now(), in units of "y" (years). Then set your criteria as < 35 for the results of the DateDiff function.

To be scrupulously correct, that's what you should do rather than subtract 35 years (in units of days) from NOW() to get the limiting DOB.

 

[Jon K]

An expression for calculating Age:

DateDiff("yyyy",[DOB],Date()) + Int(Format(Date(),"mmdd")<Format([DOB],"mmdd"))

.

 

[daveUK]

try >DateAdd("yyyy",-35,Date())

 

[rvd48]

try >DateAdd("yyyy",-35,Date())

thankyou dave, thats worked a treat