I am trying to bind a simple data source to a line series chart control, and I'm having a lot of difficulties getting the DateTime field to work. The stored procedure is very simple and returns a DateTime column and an int column that I want to chart on the Y axis.
From what I can gather the chart control needs dates in the OLE Automation date/time format? How do I do this for a data bound chart? I found this example:
but it only shows you how to do this programatically with fixed dates. Is there anything I can do to convert the DateTime field in SQL in my stored procedure in a format that the chart control understands?