How to Change the Date Field Format to DD/MM/YYYY in a SSRS report

Posted By Posted by: EPM Partners on March 25, 2014

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 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:

op1

 

Option 2

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

op2

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?

To get more news, events and blogs from EPM Partners sign up to our mailing list today by Clicking Here.


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

Leave a Reply

Your email address will not be published. Required fields are marked *