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
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