Problems with DateDIff

Results 1 to 2 of 2

Thread: Problems with DateDIff

  1. #1
    Join Date
    Dec 1969

    Default Problems with DateDIff

    How do I find an age difference(in years) between a date of birth and today&#039s date. When using DateDiff I get difference in years between the two dates but this is incorrect o calculate age:<BR>today = 22/11/00<BR>date of birth = 21/11/77<BR>DateDiff = 23<BR>age should = 24<BR>How do I get around this?<BR>Cheers Dave (

  2. #2
    Join Date
    Dec 1969

    Default RE: Problems with DateDIff

    My first guess is that you need to add a time to it. Like 12:00:00 AM to today and 12:00:00 PM to the date. Maybe I am wrong but that would be my guess.

Posting Permissions

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