Exact age (1 Viewer)
- Thread starter kolait
- Start date
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.
- Local time
- Yesterday, 21:20
- Joined
- Oct 29, 2018
- Messages
- 21,453
Hi. You'll probably need a custom function for that. You could try this one.
Last edited:
- Local time
- Today, 00:20
- Joined
- Feb 19, 2002
- Messages
- 43,223
Here's a sample database that I've posted multiple times.
- Local time
- Yesterday, 21:20
- Joined
- Oct 29, 2018
- Messages
- 21,453
Hi. You may have missed it. I added a link in my earlier post.
kolait
Registered User.
- Local time
- Today, 08:50
- Joined
- Oct 11, 2019
- Messages
- 60
thank you . it was so good . but i want to use in the quarry
- Local time
- Yesterday, 21:20
- Joined
- Oct 29, 2018
- Messages
- 21,453
Yes, you should be able to. What have you tried? Can you show us?
kolait
Registered User.
- Local time
- Today, 08:50
- Joined
- Oct 11, 2019
- Messages
- 60
Thank you . It was so good
kolait
Registered User.
- Local time
- Today, 08:50
- Joined
- Oct 11, 2019
- Messages
- 60
I wrote this but it didn't work
Attachments
-
2019-10-17_1-42-38.png
- Local time
- Yesterday, 21:20
- Joined
- Oct 29, 2018
- Messages
- 21,453
Hi. It looks like you wrote DateDiff instead of Diff2Dates.
kolait
Registered User.
- Local time
- Today, 08:50
- Joined
- Oct 11, 2019
- Messages
- 60
I wrote right but it didn't work out. Thank you for taking the time for me
- Local time
- Yesterday, 21:20
- Joined
- Oct 29, 2018
- Messages
- 21,453
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.
- Local time
- Today, 00:20
- Joined
- Feb 19, 2002
- Messages
- 43,223
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.
kolait
Registered User.
- Local time
- Today, 08:50
- Joined
- Oct 11, 2019
- Messages
- 60
Thank you for taking the time for me. I want to write age here
Attachments
-
5.png
- Local time
- Today, 00:20
- Joined
- Feb 19, 2002
- Messages
- 43,223
The query would be something like:
Select fld1, fld2, GetAge(Birthdate) As TextAge, fld4 from yourtable;
Create the GetAge() function to take in the birthdate and return the text string you want. All the pieces are in the code I provided but you'll need to put it together because I'm off to play bridge for a few days.
Select fld1, fld2, GetAge(Birthdate) As TextAge, fld4 from yourtable;
Create the GetAge() function to take in the birthdate and return the text string you want. All the pieces are in the code I provided but you'll need to put it together because I'm off to play bridge for a few days.
Similar threads
Solved
Age Deomgraphics
