Dates on reports can be a pain, you have to leave enough space for the worst case scenario, usually 12/12/xxxx, if you have a lot of date columns all that space can add up. Instead of using Short Date in the format field of the report’s format tab, use mm/dd/yy instead. It will guarantee all months and years are two digits and you can space your columns accordingly.

By the way, you can use mm, dd and yy in other combinations too:

ADVERTISING
SQL Server Hosting

dd/mm/yy – Used in Latin America
mm/yyyy – Month/Year

Start saving some trees today and use the reduced format!