Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Query Expression in Access problem

Locked

Hi all

Im tearing my hair out here!!! I am trying to work out an age from a date of birth and using the Now() function in Access.

The problem is that any date of birth over 1972 -i.e. 16/09/1973 – shows as 4 figures even though I have formatted the field to yy and zero decimal places. The formula I have used for the expression is, AGE: Now()-[dob]

Has anyone any ideas

Thanks
Brian

Topic

Query Expression in Access problem

In reply to Query Expression in Access problem

See if Dev Ashish’s instructions help. You may have to split up the answer into years, months etc.

http://tinyurl.com/grbe

Query Expression in Access problem

In reply to Query Expression in Access problem

This code works fine for me:

Dim Age, BirthDate
BirthDate = #9/16/73#
Age = Now – BirthDate
Age = Format(Age, “yy”)
Debug.Print “Age = ” & Age ‘Age=29

Query Expression in Access problem

In reply to Query Expression in Access problem

Have you tried the DateDiff function?

Reply To: Query Expression in Access problem

In reply to Query Expression in Access problem

This question was closed by the author

[Author]

Replies