Formatting date in SSRS - not working

Question

I don't know why I have such a problem with that.

I have a dataset which returns the date in the format I want: M / d / yyyyy. However, if I preview the report with the data in a table it will continue to display it as MM / dd / yyyy.

I tried to set the Format property of the text field to M / d / yyyyy, (no change) and I tried to set the expression for that field to = Format(Fields!TripDate. Value,"M / d / yyyyyy) "but only to see the actual M / d / yyyy values in the field.

What am I wrong?

I scoured the internet looking for some format option that would just drop the leading zeros on the date and nothing suggested works.

Answer 1

From your description it sounds a lot like you don't select a column from the database with a "DATE" datatype (as it's not "Formatted"), so maybe you're formatting it in the SQL SELECT?

Also, the fact that your Format expression doesn't work suggests the data is actually a string.

It is best to NOT format dates in the SQL query and just use the "format" property of the textb

Check out ssrs tutorial that helps you to gain much more knowledge.