Converting dates to age field

MANDI201

Registered User.
Local time
Today, 12:03
Joined
Nov 21, 2002
Messages
15
Help - silly problem I am sure easy for someone to solve but I am having trouble converting a date field into an age field not experienced enough to use VB managed to get query to show age by taking dob year away from current date but if person born tommorrow will still show same age as a person born yesterday! agghhh.
 
Check out the DateDiff function in Access Help:

DateDiff("yyyy",[DateOfBirth],Date()) or better yet,
DateDiff("m",[DateOfBirth],Date()) / 12
 
Last edited:

Users who are viewing this thread

Back
Top Bottom