Exact age

[kolait]

hi
In the field "A" I have a birthday. I want to find out the exact age of the year, month and day.Please help me

 

[plog]

You would use the DateDiff function (https://www.techonthenet.com/access/functions/date/datediff.php)--3 different times. Once calculating year, once calculating month and once calculating day. Then for the month and day you would have to do math (/12, 1/365, etc) to get the exact number you want.

 

[theDBguy]

Hi. You'll probably need a custom function for that. You could try this one.

 

[kolait]

Thanks for helping me...
I don't know how to make a proprietary function. Will you help me? thank you

 

[theDBguy]

Thanks for helping me...
I don't know how to make a proprietary function. Will you help me? thank you

Hi. You may have missed it. I added a link in my earlier post.

 

[kolait]

Hi. You may have missed it. I added a link in my earlier post.

thank you . it was so good . but i want to use in the quarry

 

[theDBguy]

thank you . it was so good . but i want to use in the quarry

Yes, you should be able to. What have you tried? Can you show us?

 

[kolait]

Here's a sample database that I've posted multiple times.

Thank you . It was so good

 

[kolait]

Yes, you should be able to. What have you tried? Can you show us?

I wrote this but it didn't work

 

[theDBguy]

I wrote this but it didn't work

Hi. It looks like you wrote DateDiff instead of Diff2Dates.

 

[kolait]

Hi. It looks like you wrote DateDiff instead of Diff2Dates.

I wrote right but it didn't work out. Thank you for taking the time for me

 

[theDBguy]

I wrote right but it didn't work out. Thank you for taking the time for me

Hi. Since you already have a working solution from Pat, I guess we don't have to pursue this anymore. However, saying "it didn't work" wouldn't be enough information for us to help you troubleshoot the problem, if you had wanted it fixed. So, for future reference, let us know exactly how the suggestion didn't work and provide any error message you may have received. Good luck with your project.

 

[kolait]

If you choose to use the code in my sample (or whatever code you want to use), you can put it into your own function and have the function return the text string you want. Call the function from the query.

Thank you for taking the time for me. I want to write age here