Insight CAST Text Timestamp as Date

I have a CDO with data stamps in a text field. I would like to treat them like dates and have used the following

CAST("Cotact Custom Obj 19"."ColText16" AS Date)

But I cannot seem to aggregate the column into one value for the specific date. It seems to want to still treat the date as with timestamps.