Have you had a look at the getting started guide for this product? It can be found here on the support page:
You can definitely use dates in the chart, have you setup access to the table in your db and specified the date column to use? What specifically have you tried that is not giving you the correct results? So long as you specify the proper column for the x and y axis you should be able to chart the info from those columns. Please post back with some more details and let us know a little more about how your data relates in regards to the dates.