Easy Chart: convert varchar to datetime

Hi All,

I want to Chart Value from a data base with Easy Chart. In my table the date has the format yyyy-mm-ddT hh:mm:ssZ as a VARCHAR.

In Easy Chart Customizer when I select the time Column i have this error: “The type of time column ‘date’ is not a date”.

This is normal because date is a VARCHAR

In Easy Chart, how or where can i convert this VARCHAR to a datetime?

Thank you for you help!

You will need to create a view in your database that uses CAST() or CONVERT(). Supply the view name instead of the table name.