using datetime with colorline tool

[LordWhorfin]

Hello,

I'm trying to draw a colored line at a specific point on the x-axis of my chart using the colorline tool. The x-axis is date and time, which is giving me problems. I think this should work..


Line 82: colorLine1.Axis = WebChart1.Chart.Axes.Bottom
Line 83: colorLine1.Pen.Color = Drawing.Color.Yellow
Line 84: colorLine1.Value = "8/21/2007 11:14:00 AM"
Line 85:

But I get the following error..

Exception Details: System.FormatException: Input string was not in a correct format.

Can you tell me what I'm doing wrong?

cheers, Paul

[Narcís]

Hi LordWhorfin,

You should use something like this:

Code: Select all

			colorLine1.Value = DateTime.Parse("8/21/2007 11:14:00 AM");

[LordWhorfin]

Hi LordWhorfin,

You should use something like this:

Code: Select all

			colorLine1.Value = DateTime.Parse("8/21/2007 11:14:00 AM");

That generates an error..

Conversion from 'Date' to 'Double' requires calling the 'Date.YoOADate' method.

[Narcís]

HI LordWhorfin,

Sorry, what about this then?

Code: Select all

         colorLine1.Value = DateTime.Parse("8/21/2007 11:14:00 AM").ToOADate();

[LordWhorfin]

HI LordWhorfin,

Sorry, what about this then?

Code: Select all

         colorLine1.Value = DateTime.Parse("8/21/2007 11:14:00 AM").ToOADate();

That did it, thank you. Paul