# Easy chart question **URL:** \ **Category:** Ignition\ **Created:** [July 27, 2016, 12:54pm UTC](https://forum.inductiveautomation.com/t/easy-chart-question/11977 "2016-07-27T12:54:41Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![iheartada](https://avatars.discourse-cdn.com/v4/letter/i/6de8d8/32.png) [@iheartada](https://forum.inductiveautomation.com/u/iheartada)\ **Post date:** [July 27, 2016, 12:54pm UTC](https://forum.inductiveautomation.com/t/easy-chart-question/11977/1 "2016-07-27T12:54:41Z")
Hello I am trying to chart a db entry with easy chart. The table I want to chart has two columns, date and date. date is type date with getdate() default value. Data is type float. (I am using sql server) When I goto pen database select the proper things, when I run Diagnostics it says ‘The type of time column ‘date’ is not a date.’ If I goto chart the error I get is "IllegalArgumentException: Illegal type for x value: class java.lang.String (column ‘date’) using the query select data, date from tablename sample data from dataset viewer date | data yyyy-mm-dd | 1 yyyy-mm-dd | 2 ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [July 27, 2016, 10:15pm UTC](https://forum.inductiveautomation.com/t/easy-chart-question/11977/2 "2016-07-27T22:15:03Z")
Try: ```auto SELECT CONVERT(DATETIME, date) as date, data from tablename ``` It could be that your date column is not being correctly interpreted as a date value. ---
**Author:** ![iheartada](https://avatars.discourse-cdn.com/v4/letter/i/6de8d8/32.png) [@iheartada](https://forum.inductiveautomation.com/u/iheartada)\ **Post date:** [July 28, 2016, 1:31pm UTC](https://forum.inductiveautomation.com/t/easy-chart-question/11977/3 "2016-07-28T13:31:09Z")
that was it. Thank you!!!