SSRS: Custom Date Formatting

Applying a custom format to date values.

Since most date values returned in a dataset aren’t very intuitive due to their default precision, applying a custom format helps the user to understand them better.

To illustrate how to accomplish this task, I’ll begin where the Global Collections article ended.

As you can see, the report displays date values for the Hire Date column that are difficult to read to their long precision.


Instead, I’d like the date values to be much shorter – just a two digit month and year.

To apply a custom date format to this field, I’ll add an expression to the Font property of the textbox.


Now when I execute the report, the Hire Date values are much simpler to read.


Download Report
(right-click, Save As)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s