How to Change the Date Field Format to DD/MM/YYYY in a 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 three options for when you select the textbox property dialog box:

Option 1

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

Option 2

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

Option 3

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

format(Fields!FieldName.Value,”dd-MMM-yyyy”)

We hope this helps you.

Was this information helpful?