How to change the date field format to DD/MM/YYYY in SSRS report


  1. Open the report in the Business Intelligence Development Tool (BIDS)/SQL data tool
  2. In the design mode, right click the date textbox and click on properties.
  3. You have multiple options to do this task. Here are the options when you select the textbox property dialog box –

Option 1

Select the tab Number’ then category Date’ then you can select the appropriate date format to display in the report. Refer below snapshot:


Option 2

Select the tab ‘Number’ then category ‘Custom’ then provide the custom format as per below snapshot.



Double click on the date field in the design mode and use the below function to change the date format. You need to replace the highlighted text with your Date field Name


Hope this helps you.


Leave a Reply

Please log in using one of these methods to post your comment: Logo

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

%d bloggers like this: