Is it possible to convert date of birth and calculate age within a single query

[rinova]

Hi Everyone,

Hope everyone is doing well, I need some help. I need to know if it is possible to convert a date of birth (Ex: CCYYMMDD to MM/DD/CCYY and calculate age within a single query?

Thank you,

Rinova

 

[theDBguy]

Yes. It should be possible. Is your date of birth field Text or DateTime data type?

 

[rinova]

Date of birth is text

 

[theDBguy]

Date of birth is text

For starters, then, you could try the following to see if it converts Text to Date.

CDate(Format([DOB],"@@@@-@@-@@"))

 

[rinova]

I use CDATE to convert my DOB from CCYYMMDD to MM/DD/CCYY

CDate(Mid([DOB],5,2) & "/" & Right([DOB],2) & "/" & Left([DOB],4))

But I like yours better

 

[theDBguy]

I use CDATE to convert my DOB from CCYYMMDD to MM/DD/CCYY

CDate(Mid([DOB],5,2) & "/" & Right([DOB],2) & "/" & Left([DOB],4))

But I like yours better

Yeah, there's always more than one way to get something done in Access, for sure. Let us know if you need further assistance. Good luck!