SSRS report displayed using ReportViewer (windows): Is it possible to format the datetime displayed as MM/dd/yyyy? Currently displays as MM/dd/yy RRS feed

  • Question

  • We call the ReportViewer from our .NET app.  We have an SSRS report that has two date parameters (From/To).  We pass parameter values from the .NET app to the report viewer.  If the end user selects all dates, we pass through 01/01/1900 - 12/31/9999.  The ReportViewer displays data for All Dates.  The report viewer displays these parameter dates as 01/01/00 and 12/31/99.  The problem arises when the user clicks View Report, the report no longer returns data. The reason why is that the ReportViewer has now translated the dates 01/01/00 - 12/31/99 from 01/01/1900 - 12/31/9999 to 01/01/2000 - 12/31/1999..  If I manually type in 01/01/1900 and 12/31/9999 and click View Report again, then the report returns data.  But again, the dates are formatted as 01/01/00 - 12/31/99.  Is there a way to display the date value the end user sees in the date parameter using the century format (MM/dd/yyyy vs MM/dd/yy)?

    Thursday, May 6, 2010 1:46 PM


  • The answer lies in the Date format in Regional Settings Short Date Format

    I changed my date to MM/dd/yyyy (it was MM/dd/yy), ran the report through ReportViewer control & the date is now showing in the format MM/dd/yyyy.

    • Marked as answer by N11689 Thursday, May 6, 2010 7:48 PM
    Thursday, May 6, 2010 7:47 PM