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.