Age Calculations Help DEADLINE TODAY

[rynorem]

This is probably an easy criteria but I'm getting close to COB and I have to have it in today.

I have a DOB as (DD Mon YY 04 Jul 79) in which I need to create a column for thier age. Then I have to show all the people who are over 60 years old. I can't even get thier age to show correct. Any help. Thanks

 

[Liv Manto]

round = rounds it up to 2 decimal places.

Now() = todays date.
"d" = days
so divided by 364 (or +.25) for every day in a year..

Expr1: round((DateDiff("d",[Contacts]![bday],Now())/364),2)

 

[EMP]

An accurate expression for age:-

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


You can put >60 in the criteria.

^

 

[rynorem]

I keep getting a Data Type Mismatch in the criteria expression. Any suggestions?

 

[Liv Manto]

Check the data type of your date.

I was assuming its medium date. If its not a date at all but text, try creating another field data type date ,then update the field from the text data.. Dont just change it from text to date, you might lose your data.

Then use the new field for the expression.

 

[dedwards1960]

Yout age problem

I was trying to do the same thing.

With DOB and Now()

This is what I found and it works.

I put this in my query

AGE: DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))

then in the criteria I put this >=[Enter Age] example 60
this will so all people 60 and over.

Hope this helps your deadline.

 

[EMP]

My simpler expression:
Age: DateDiff("yyyy",[DOB],Date()) +(Format(Date(),"mmdd")<Format([DOB],"mmdd"))

should also work. It was taken from Jon K's sample database:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

I keep getting a Data Type Mismatch in the criteria expression.

I think the problem is that the poster probably used a text field to store the dates.

^