Formatting Datetime in ReportViewer Chart to Show Only Date

RDeWolfe
RDeWolfe used Ask the Experts™
on
I'm pretty new to the Visual Studio ReportViewer, and I'm having a problem formatting a datetime value on a ReportViewer chart.  In the chart itself I have dates along the X-axis which all display in the standard dd/mm/yyyy hh:mm:ss format.  Well, the hh:mm:ss values will always be 12:00:00 am, so I would like to just remove this from the display.  I'm sure there is a simple way to do this, and I am just missing it.  Can someone point me in the right direction?  Let me know if you need anything from me.  Thanks in advance for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
try any of these

SELECT CONVERT(varchar, DateColumn,101) DateColumn
SELECT CONVERT(varchar, DateColumn,103)DateColumn  

Author

Commented:
Thanks for the quick response.  Sorry if this seems naive, but try them where?  Try them in the SQL query itself, or can I format the value in the properties of the chart somewhere?
AneeshDatabase Consultant
Top Expert 2009

Commented:
i am not sure abt that part
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Format in properties

d

Author

Commented:
SQL_SERVER_DBA:
This works for a text field on the report, but when I set it on my chart - it has no effect.  How can I adjust the format properties of the 'category' on the x-axis?  This is where the dates are.
Commented:
I was able to figure this issue out using the "=format(now(), "MM-dd-yyyy")" expression in the label properties.  Thank you for your responses.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial