SSRS : Changing how a date and time is displayed to UK
(dd/mm/yyyy) format

Category : Tips Published : January 14, 2015 User Rating : 4.5 Stars      Views : 3.5 Stars
One Click Feedback
Please help us to improve the site by rating the quality of this article by clicking a button below.




Reporting Services may not display dates and times in the format you want or were expecting. Fortunately if you want to set an explicit format (such as dd/mm/yyyy) for a field on a report then it’s straightforward to do this, and without using any code or expressions. To demonstrate this I’ve created a very simple report that displays the contents of the Production.ProductCategory table on the AdventureWorks2008R2 sample database using a tablix. When I run the report on my computer the datetime field in that table is displayed in a US format format, as follows :
SSRS SSRS report with default date format

However I can change the format so that it displays the field as dd/mm/yyyy (or any other format – see below for some details on that), as follows :
SSRS report with UK date format

To change the format select the textbox control in the report designer, click on F4 to display the properties window and enter dd/MM/yyyy for the format property (using an upper case M as lower case is for minutes), as follows :
SSRS report with UK date format in BIDS

There are plenty of other date formats to choose from, here are a few examples for UK style dates and times :

FormatResult
dd/MM/yyyy01/06/2002
dd/MM/yyyy HH:mm:ss01/06/2002 21:43:01
dd/MM/yyyy hh:mm:ss tt01/06/2002 09:43:01 PM
dd MMMM yyyy01 June 2002
dddd d MMMM yyyySaturday 1 June 2002

Related Articles

The following articles may also be of interest :

Link back to this article : http://www.sqlmatters.com/Articles/SSRS Changing how a date and time is displayed to UK (ddmmyyyy) format.aspx

Keywords

SSRS, BIDS, Report Builder,SQL 2012, 2008, 2008R2


Comments

Post a comment   No login required !

 
Name :   Email :   Website :  
Will be displayed alongside your comment
Not displayed Optional, but displayed if entered