Hello!

I have used this successfully for a few months and all data was enclosed in ' '

For some reason, I have lost the '' around the date. by looking at the query, and then looking at the results, can anyone help?

BEGIN UNLOAD SELECT phone_home_client, creationdate, appt_time, staff_email, - Pastebin.com (If you would like to view there)

BEGIN
UNLOAD
SELECT phone_home_client, creationdate, appt_time, staff_email, crecordnumber, employeesid, appt_agency
FROM outcomes WHERE phone_opt_in = 'Yes' AND specifier1 = 'Referral' AND DATE(creationdate) = DATE(DATEADD(day,2,NOW()))
TO '/srv/phonedialer_out/phase2sys1.csv';
END


'(252) 947-0261',2011-06-30 12:24:41.976,'9:30 am','sklund@coastalhorizons.org','COOL010180','KLU NSTEV0508','Tracie''s Really bad place'



Thanks