How to Calculate Age Using a Date of Birth IN MS ACCESS QUERY

preview_player
Показать описание
In this video, we will walk you through the process of calculating age by subtracting the date of birth from the current date, and then dividing the result by 365.25. The 'Int' function is used to round off the resulting decimal number to the nearest whole number
AGE: Int((Date()-[DateOfBirth])/ 365.25
If you found this video helpful, please like, comment, and subscribe to our channel for more MS Access tutorials. Thank you for watching, and we'll see you in the next video!
Рекомендации по теме
Комментарии
Автор

Hello! What if you will use a specific date instead of “date now”? How will you show it? Thank you!

jaybycabangin
Автор

This is helpful. However, how can you allow age to appear on the table instead of query?

lautechsolutions
Автор

This is helpful. However, how can you allow age to appear on the table instead of query?

lautechsolutions