Formatting dates in Reporting Services

  • I have created a report template where I use the global variable for Execution time. The expression in the report look like this; =FormatDateTime(Globals!ExecutionTime,2). The figure 2 in the expression means that the date should be formatted as short date. In the documentation I have read should the date be displayed as the regional settings are on the computer. In my case I use the swedish settings.

    But when rendering reports based on the template in Internet Explorer the date isn't shown as my regional settings. The date is shown in short date but not the swedish way. In my case the date should be shown as YYYY-MM-DD but it's showing mm/dd/yyyy.

    Niklas

  • may be this link will help understand: http://msdn2.microsoft.com/en-us/a912f2a0(VS.71).aspx

  • There is a langauage associated with each report.

    View the report in layout mode, click in the blank area beneath the report details and hover over the properties tab to reveal the report properties (this is different to selecting Report | Properties from the menu).

    The report language can be changed here.

     

  • Thanks for the answer. Now it works as I want to. I have never been aware about this properties before.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply