Date display with text format is giving me error in ssrs.

  • I have the following code which is giving me an error in ssrs. It shows "error" in that text box. I don't understand why.

    =YEAR(Fields!REPORT_END_DATE.Value) + " Campaign" + "((Jan to Dec " + YEAR(Fields!REPORT_END_DATE.Value) + ")"

    When I just run YEAR(Fields!REPORT_END_DATE.Value), I get the correct result. However, when I try to include the text I get error.

    Please kindly let me know what could I be doing wrong here.

  • I resolved the issue. I needed to use & instead of +

    =YEAR(Fields!REPORT_END_DATE.Value) & " Campaign" & "((Jan to Dec " & YEAR(Fields!REPORT_END_DATE.Value) & ")"

  • "an error"? What is the error (displayed in the Error list pane)?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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