OK So doing some more research people recommended creating a view to convert the the clarion date/times. The problem is I can only seem to convert the DATE column...