ADO Binding and DateTime

[User (Legacy)]

Hi:

I have a recordset that returns a datetime data type and I want to display

that field as a Label in the X Axis.  what is happing is that the ChartFx

only display the date and not the Date and time ex. 09/01/2001 instead of

09/01/2001 01:02:22 AM.  If I bind the recordset to a grid i get the date

and time like i want to so i know the recordset has the information.

I change my query with a convert function to convert the field to char and

it return for ex. Aug 31 2001 5:35PM. and that is what ChartFx display as X

axis  Label.

Thanks

[Software FX]

You don't have to change your query, use the Format property of the X axis

to select how your date/times should be displayed. There are samples showing

this at http://support.softwarefx.com/cfxie , Select ASP Samples and then

"Data Related"

--

Regards,

JC

SoftwareFX

"Julio Delgado" <jdelgado@jagautomation.com> wrote in message

news:z$zuL22MBHA.2200@webserver1.softwarefx.com...

> Hi:

>

> I have a recordset that returns a datetime data type and I want to display

> that field as a Label in the X Axis.  what is happing is that the ChartFx

> only display the date and not the Date and time ex. 09/01/2001 instead of

> 09/01/2001 01:02:22 AM.  If I bind the recordset to a grid i get the date

> and time like i want to so i know the recordset has the information.

>

> I change my query with a convert function to convert the field to char and

> it return for ex. Aug 31 2001 5:35PM. and that is what ChartFx display as

X

> axis  Label.

>

> Thanks

>

>