Help with Chart Component

[Log Date] is a “Date” datatype in MSQL
Using this query the Chart errors with" Illegal type for X value"
SELECT [Log Date] as t_stamp, [TR#1 Today permeate (kL)] FROM datalogA

This Query has no errors, but fails to display
SELECT cast([Log Date] as datetime) as t_stamp, [TR#1 Today permeate (kL)] FROM datalogA