Calculating age from date of birth

Results 1 to 2 of 2

Thread: Calculating age from date of birth

  1. #1
    Join Date
    Dec 1969

    Default Calculating age from date of birth

    How can I display a persons correct age from a date of birth(format dd/mm/yy)? When using DateDiff("yyyy" Dob, Date) i get the difference between the years but not the correct age. Thanks

  2. #2
    Steve Cimino Guest

    Default RE: Calculating age from date of birth

    From the help file:<BR><BR>When comparing December 31 to January 1 of the immediately succeeding year, DateDiff for Year ("yyyy") returns 1 even though only a day has elapsed.<BR>-----------------------------------------------------------<BR><BR>Looks like you&#039re going to have to extend your function to check months and dates also. <BR><BR>Settings<BR>The interval argument can have the following values:<BR>Setting Description <BR>yyyy Year <BR>q Quarter <BR>m Month <BR>y Day of year <BR>d Day <BR>w Weekday <BR>ww Week of year <BR>h Hour <BR>n Minute <BR>s Second <BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts