DateDiff won't work in query expression

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I created a query expression that will not work and I
can't understand why.
AgeatYrEntry: DateDiff("y",[DOB],[02-03 Entry Date])
Where DOB is the person's date of birth and 02-03 Entry
Date is the date they entered our program. The result is
a number in the 1000's, and the answer should be in the
teens. Is this not working because of the fact that their
DOB is before 2000 and their entry date is after 2000?
Bill
 
Bill said:
I created a query expression that will not work and I
can't understand why.
AgeatYrEntry: DateDiff("y",[DOB],[02-03 Entry Date])
Where DOB is the person's date of birth and 02-03 Entry
Date is the date they entered our program. The result is
a number in the 1000's, and the answer should be in the
teens. Is this not working because of the fact that their
DOB is before 2000 and their entry date is after 2000?
Bill
Click to expand...

You need "yyyy" for year, "y" is day-of-year and will give you the result in days.
 
Back
Top