datetime with hours on chart

[User (Legacy)]

Our query returns 24 rows with each one having a field that is a datetime 

with the day and the hour. example : 08/06/2006 12:00:00.

When putting the datetime field on the x-axis, and formatting it to show 

hours, on the midnight hour (00), shows up.  How do we get all of the dates 

to appear?

-Lori

[User (Legacy)]

Our query returns 24 rows with each one having a field that is a datetime 

with the day and the hour. example : 08/06/2006 12:00:00.

When putting the datetime field on the x-axis, and formatting it to show 

hours, on the midnight hour (00), shows up.  How do we get all of the dates 

to appear?

-Lori

[User (Legacy)]

I figured it out.  Have to change the format for the x-axis to datetime 

instead of date.

-Lori

"Lori Adams" <ladams@cloudmark.com> wrote in message 

news:7v1eTaYvGHA.1292@webserver3.softwarefx.com...

> Our query returns 24 rows with each one having a field that is a datetime 

> with the day and the hour. example : 08/06/2006 12:00:00.

>

> When putting the datetime field on the x-axis, and formatting it to show 

> hours, on the midnight hour (00), shows up.  How do we get all of the 

> dates to appear?

>

> -Lori

>

[User (Legacy)]

I figured it out.  Have to change the format for the x-axis to datetime 

instead of date.

-Lori

"Lori Adams" <ladams@cloudmark.com> wrote in message 

news:7v1eTaYvGHA.1292@webserver3.softwarefx.com...

> Our query returns 24 rows with each one having a field that is a datetime 

> with the day and the hour. example : 08/06/2006 12:00:00.

>

> When putting the datetime field on the x-axis, and formatting it to show 

> hours, on the midnight hour (00), shows up.  How do we get all of the 

> dates to appear?

>

> -Lori

>