Time as x-axis on chart.

[Joshy]

I have the field [Time], [Transmissivity]... and various other items as data to be shown on a standard line-chart, where [Time] represents the x-axis while everything else on the y. My problem is that the chart shows the date before the time (as in 1899/12/30 7:00 AM), but of course I only want the time to be displayed. I figured that 1899/12/30 is probably the default date or the first date registered by the program or something... But anyhow, I just need the time of the day to be shown, this is probably an easy problem to fix, but I been tripping over it for the past while, any help is appreciated.
thanks.
Josh

 

[ghubbell]

Hi Joshy,
Take a look at the underlying query for the chart and run it on its own to see the date/time format. You may have to make some format adjustments there. Gord
ghubbell@total.net