CMS Report - Date and Time (interval) with Chart???

[PeteBull]

I am working on an interval chart that covers multiple days, I cannot figure out how to get the date to show correctly on the X-Axis with the interval, currently it shows "0/0/0 1:30" (or whatever the interval is). So I have a bunch of "0/0/0 {interval}" along the bottom of the chart...

How can I get the chart to show the actual date and the interval along the bottom (x-axis) on this chart?

Inputs:
dates (multi)
split/skill (multi)
time (multi)

Query:
select ROW_DATE, STARTTIME, AVG_ANSWER_SPEED FROM hsplit where ACD=$acd AND ROW_DATE = [Dates:] AND SPLIT = [Splits/Skills:] AND STARTTIME = [Times:] ORDER BY Row_date,Starttime

any help is greatly appreciated.

 

[Stinney]

Under the Chart Format Options, Catagory: check the Show All Formats and then you can select a format that shows the date and time format you want.

- Stinney

Quoting only proves you know how to cut and paste.

 

[PeteBull]

that's how I got the 0/0/0 to show up instead of just the time. I need it to show the actual date, not 0/0/0.

Thanks