I hope someone can help I'm pulling my hairout here. I know there are a few threads already on this, but none of them are helping me.
I have two columns in a datatable. OrderDate and OrderTotal.
I've got this code.
RadChart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 45
RadChart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.LongDate
RadChart1.PlotArea.XAxis.DataLabelsColumn = "OrderDate"
RadChart1.DataSource = dtOrders
You've already probably guessed what my question is. This errors becuase I believe the OrderDate is not in the correct format and I need to us toAODate() in order to make this work. Great, how? Do I have to convert the data in the datatable with this function? How do you use it? I've looked at the microsoft page, it didn't shed any light for me.
I understand that;
Dim SomeDateAsADouble as Double
DatetoConvert as Date = Today()
SomeDateAsADouble = DatetoConvert.ToAODate()
How does this help with the above problem?
RadChart1.PlotArea.XAxis.DataLabelsColumn = "OrderDate".ToAODate() ;This won't work
Please can someone help me, and anyone after me with an explained solution. I really would appreciate it.