none
RDLC report doesn't format values in DATE format or number Format as set in placeholder settings. RRS feed

  • Question

  • Hi,

    I have a RDLC in a VS 2010 Windows app coded in VB.

    In the RDLC I have a table with a Date, Location and Details columns.

    For the Date I have its expression set to =Fields!date.Value.

    And then under properties I tried to set the format to a Date format so that it returns something like 10 Jun 2010, however the formating does not get applied when I run the report it still shows it as 10-06-10 as in YY-MM-DD.

    Why is it not taking any applied formating? Screenshots below.

     




    Thursday, June 10, 2010 7:01 AM

All replies

  • What is the datatype of the field in the datatable feeding the report? I bet it's a string.

    Change that to a datetime field in your datatable and the formatting will work on the report.

    Bernie

     

    Thursday, June 10, 2010 3:19 PM
  • Use This Expression Like This

    =Format(Globals!ExecutionTime,"yyyy/MM/dd")

    Tuesday, March 11, 2014 2:54 AM