Datetime Parameter Report Builder

Question

I am using Report builder. Is there any ways to display the date of datetime parameter in dd-MMM-yyyy ( 1-Mar-2017) format?

Do you mean you want to the date format in the date picker to match that? — R. Richards, Mar 06 '17 at 01:22
http://stackoverflow.com/questions/38202281/change-datetime-format-in-date-picker-ssrs — R. Richards, Mar 06 '17 at 01:47
thanks for reply! However, I can't find the (1-Mar-2017) format after i deployed it. — Noobie, Mar 06 '17 at 01:53

score 1 · Answer 1 · answered Mar 06 '17 at 01:06

1

SQL Server's CONVERT() function should be able to handle this:

SELECT CONVERT(varchar, date, 106) AS date_formatted
FROM yourTable

Here date is the column containing dates which you want to format as you specified in your question.

answered Mar 06 '17 at 01:06

Tim Biegeleisen

1 Answers1