Question Status

Verified
Shane Brown asked a question on 6 Oct 2017 4:28 PM

Hi i am wanting to create an expression in SSRS to return "2017 - 2018" based on the startdate field and enddate field. I cannot get it to work any ideas?

=(Format(First(Fields!S_StartDate.Value, "MemberDetails"), "yyyy") + " - " + (Format(First(Fields!S_EndDate.Value, "MemberDetails"), "yyyy")

Thanks

Reply
Verified Answer
Shane Brown responded on 6 Oct 2017 5:16 PM

ignore i have fixed the issue ="Year "+ (Format(First(Fields!S_StartDate.Value, "MemberDetails"), "yyyy")) + " - " + (Format(First(Fields!S_EndDate.Value, "MemberDetails"), "yyyy"))

Reply
Verified Answer
Shane Brown responded on 6 Oct 2017 5:16 PM

ignore i have fixed the issue ="Year "+ (Format(First(Fields!S_StartDate.Value, "MemberDetails"), "yyyy")) + " - " + (Format(First(Fields!S_EndDate.Value, "MemberDetails"), "yyyy"))

Reply