Calculate age in completed years on a report date (library cards)
Work out each member's age on 30 June 2026, counting only birthdays that have already happened.
- Level
- advanced
- Time
- ~10 min
- Task
- Build the query
- Access
- Pro
Checking your access…
About this exercise
What you'll practise
Do exact calendar arithmetic instead of dividing days by 365.
The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.
Input
- Members (table)
- MemberID: text
- BirthDate: text
Expected output columns
MemberID (text), Age (number)