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

Solution:

  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:

op1

Option 2

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

op2

Option3

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

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

Hope this helps you.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: