Post reply

Date Expression

  • October 10, 2014 at 2:59 am

    #397487

    Hi, I have this date expression bellow, please correct it, I'm not sure about "&"

    =IIF(Format(Parameters!Start_Date.Value, "MMM") = Format(Parameters!End_Date, "MMM") & Format(Parameters!Start_Date.Value, "yyyy") = Format(Parameters!End_Date, "yyyy"), Globals!ReportName & " from " & Format(Parameters!Start_Date.Value, "dd") & " - " & Format(Parameters!End_Date.Value, "dd MMM yyyy"), "")

    What should it perform:

    If the date it's in the same month, I want something like this; e.g 1-27 Aug 2014

  • October 10, 2014 at 3:09 am

    #1751524

    I also tried

    =IIF(Format(Parameters!Start_Date.Value, "MMM") = Format(Parameters!End_Date, "MMM"), IIF(Format(Parameters!Start_Date.Value, "yyyy") = Format(Parameters!End_Date, "yyyy"), Globals!ReportName & " from " & Format(Parameters!Start_Date.Value, "dd") & " - " & Format(Parameters!End_Date.Value, "dd MMM yyyy"), ""), "")

    But I'm still not getting it right.

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

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