how to include person's age in a query

English
#1

I have a Base table with a “Birth Date” field in format mm/dd/yyyy. How do I get a query to show listed member’s age?

#2

Hello,

You do not specify what database you are using. Also, dates are always stored in the database as YYYY-MM-DD regardless of the displayed format.

For a Firebird database, see answer in this post → FireBird, Libreoffice Base DATEDIFF.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.