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.

1-custom-date-format

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.

2-custom-date-format

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

3-custom-date-format

Download Report
(right-click, Save As)

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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