Date Format Change

[Jkelly228]

Hello All,

I have a bar chart that uses the Qty for Orders along the "Y" axis and Dates along the "X" axis. The report looks very good, however, the Date also includes Time stamp as well. I have gone into Style -> Data Format and changed it to not show the time information, but this has not changed the actual format.

Does anyone know why this may be happening. I have noticed that on most of my reports that this is the case and yet the format option never works. I am trying to trunc the data or something, but so far with no success. I appreciate any help that can be provided.

Kelly

[Jkelly228]

I actually found out how to do it. The rtrim function

rtrim ([Promised_Date],8) worked.

I thought I had tried that on numorous occasions, but it seems to be fine now.

Kelly