calculating age.

[ckitzman]

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

Dob is stored yyyyddmm

I thought this above function looks ok. When I run it, I get a data type mismatch in criteria expression.

What am I missing?
Any help would be appreciated.
Thanks

 

[namliam]

DOB has to be a date/time field, you have a string... this is causing the problem

Try using the function DateSerial to transform the string to a date and ... it should work

 

[ckitzman]

DOB has to be a date/time field, you have a string... this is causing the problem

Try using the function DateSerial to transform the string to a date and ... it should work

Like this?:
DOB: Mid([date_of_birth],5,2) & "/" & Mid([date_of_birth],7,2) & "/" & Mid([date_of_birth],1,4)

I have this in the same query. I'm not familiar with DateSerial, sorry.

 

[RuralGuy]

Have you looked up DateSerial in VBA Help to see how it works?

 

[ckitzman]

Have you looked up DateSerial in VBA Help to see how it works?[/QUOTE

obviously not. i don't know VB, just a rookie trying to get rid of a pesky error.
Thanks

 

[RuralGuy]

Well don't take this wrong but do you plan to be a rookie forever? These forums are usually to help people help themselves. Do you need help getting to VBA Help?

 

[ckitzman]

Well don't take this wrong but do you plan to be a rookie forever? These forums are usually to help people help themselves. Do you need help getting to VBA Help?

naw, i got it. thanks. I was trying to do too many things in one query. I separated the steps out and it's working fine now. Thanks