Thanks Jason, appreciate your help. That seems easier how i add to the existing WA Data Assist code:
SELECT clients.ClientID, clients.ClientUserID, clients.App1Title, clients.App1FirstName, clients.App1LastName, clients.App1DOB, clients.App1House, clients.App1Street, clients.App1City, clients.App1County, clients.App1Zip, clients.App1Country, clients.App1Email, clients.App1Phone, clients.App1Mob, clients.ReferredBy, clients.InitialEnquiry, clients.Status, clients.App2Title, clients.App2FirstName, clients.App2LastName, clients.App2DOB, clients.App2House, clients.App2Street, clients.App2City, clients.App2County, clients.App2Zip, clients.App2Country, clients.App2Email, clients.App2Phone, clients.App2Mob, DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(App1DOB, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(App1DOB, '00-%m-%d')) AS App1Age, DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(App2DOB, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(App2DOB, '00-%m-%d')) AS App2Age
WHERE ClientID = ParamClientID OR ( -1= ParamClientID2 AND ClientID= ParamSessionClientID)
that is what the wizard created for my variables i have just added in the age so i can calculate the age from date of birth on my page.
could you tell me would i delete an existing variable or add a new one and how would i add this to my existing WA code?
thank you jason for your help on this one.