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)