In the Chart properties, go to the appropriate axis tab.
In the format code type d or D
Lowercase d is the short date format, upper case is the long format. Both exclude time.
The actual format shown depends on the reports language settings.
If the reports language property is United States (the default - annoyingly!) then it will be formatted to US standards.
If you change it to =User!Language then the format will be based on the locale of the user running the report.
Here is a link to all the other format codes you can use;
http://msdn.microsoft.com/
Main Topics
Browse All Topics
by: mwvisa1Posted on 2009-08-04 at 07:39:55ID: 25014306
You can use the techniques showed in your other question to truncate / remove the time portion; however, as soon as you convert back to a DATETIME it will most likely add by 00:00:00.000 representing midnight on that date.
Therefore, you may have to do the conversion on the MS SQL side for SSRS using CONVERT:
http://msdn.microsoft.com/
SELECT CONVERT(VARCHAR, your_date, 103) -- code 103 is british format dd/mm/yyyy
However, since you want numerical value in the chart, you may want to convert the date to an integer value representing the days since date 0. Can probably research the equivalent for PL/SQL / Oracle.
SELECT DATEDIFF(d, 0, your_date)
So no matter what the timestamp is the integer number of days will be same for any time of same day.
Hopefully that makes sense.