Re: [MSAccessProfessionals] Age Calculation

To get the date from parts you can use DateSerial(yyyy,mm,dd). Doug Steele has a function to return the format you want: http://www.accessmvp.com/DJSteele/Diff2Dates.html

Duane

Sent from my mobile

On Apr 19, 2021, at 5:58 AM, Youssef <youssef2309@gmail.com> wrote:

Dear All,

Hope you are all fine,

I have an Access form that contains a person birthdate and its written in 3 textboxes for day - month - year so I need to write VBA code to convert the data of this three textboxes to a date and then calculate current age of a person then view the result as (years-months-days)

Thanks in advance