I have two tables, one with personal information, like data of birth. And another table with transaction date. They can be joined via a Cust_ID. Is there a way, during the load process to computer the difference in these two dates for a customer for all of her or his corresponding transactions?
In other words, I want the age of a person at the time of the transaction, but the two dates are in different tables and doing the age calculation at the time of displaying the chart is unacceptably slow.
Didn’t work. Here is a snippet of my code. What it gets to the line with ContactAge, I get an error message about not finding birthday.
age(today(),Birthday) as CustAge,
Year(Birthday) as BirthYear,
date(Birthday) as dob,
SQL SELECT *
date(SessionDate) as SessDate,
age(SessionDate, Birthday) as ContactAge,
SQL SELECT *
Daniel W. Farrow, IV
DISCLAIMER: This e-mail and any files transmitted with it may contain confidential and/or proprietary information. It is intended solely for the use of the individual or entity who is the intended recipient. Unauthorized use of this information is prohibited. If you have received this in error, please contact the sender by replying to this message and delete this material from any system it may be on.