<div>
try any of these <br />
<br />
SELECT CONVERT(varchar, DateColumn,101) DateColumn<br />
SELECT CONVERT(varchar, DateColumn,103)DateColumn &nbsp;
</div>


try any of these

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

<div>
Thanks for the quick response. &nbsp;Sorry if this seems naive, but try them where? &nbsp;Try them in the SQL query itself, or can I format the value in the properties of the chart somewhere?
</div>


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?

<div>
Format in properties <br />
<br />
d
</div>


<div>
SQL_SERVER_DBA:<br />
This works for a text field on the report, but when I set it on my chart - it has no effect. &nbsp;How can I adjust the format properties of the 'category' on the x-axis? &nbsp;This is where the dates are.
</div>


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.

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


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.

Formatting Datetime in ReportViewer Chart to Show Only Date

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.