01 May 2012

How to Change Date Format in .RDLC reports (MM/dd/yyyy)

In my Report Design i want to show date in the format of (MM/dd/yyyy). The column has the value in dd/MM/yyyy.  The output on the webform looks like this: 05/18/2012 to do this follow the below steps.
Step1: In RDLC design right click on the column/textbox and then it will open context menu as shown below then select the Expression option from the menu.
Step 2:When click on Expression then it will open a windows as shown below. Change the Expression statement as shown and then click on OK button.


8 comments:

  1. But is Not Working..Getting Output in " dd/MM/yyyy"

    What Will Do.........................

    ReplyDelete
  2. This is not right method. Please go to the format area and just type d

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. This is not right method use it.

    =CDate(Fields!RegestrationDate.Value).ToString("MM/dd/yyyy")

    just change the ToString() format and get the required date what u want.

    ReplyDelete
  6. YOu Can Try This For The Regarding Date Format...............

    format(Cdate(Fields!Demo.Value),"dd/MM/yyyy")

    ReplyDelete
  7. cdate(now(),TOString("dd/MM/yyyy")
    need solution this is not working

    ReplyDelete