data connection table date help
 

I have data connection pulling a SQL query, I am using:

CONVERT(VARCHAR(10), TASK_DATE_CREATED, 101) AS [Task Orig Date]

to create the Task Orig Date field. However, this is not putting it into my data table as a 'date' automatically and is imported as text initially (I have to 'activate' the cell, then leave the cell to have it count as a 'date').
I can write VBA to go through the entire range cell by cell and do this, but does anyone know a systemic way to have the data import as a date to begin with? is there other info you need to know to help? Gracias amigos!

Thanks bác, giá»� mình má»›i biết đến thông tin hữu Ã*ch nÃ*y. Ai có những thông tin dạng nhÆ° thế nÃ*y post lên cho má»�i ngÆ°á»�i cùng tham khảo luôn nhé. Ä�ang rất quan tâm

Thanks bác, giá»� mình má»›i biết đến thông tin hữu Ã*ch nÃ*y. Ai có những thông tin dạng nhÆ° thế nÃ*y post lên cho má»�i ngÆ°á»�i cùng tham khảo luôn nhé. Ä�ang rất quan tâm