Current Date 1

with member measures.test1asformat(dateadd("yyyy", -5, now()), "Medium Date")member measures.test2asinstr(format(dateadd("yyyy", -5, now()), "Medium Date"), ",")member measures.test3as"[" + mid(format(dateadd("yyyy", -5, now()), "Medium Date"), 2 + instr(format(dateadd("yyyy", -5, now()), "Medium Date"), ",")) + "]"member measures.[5YearBackSales]as(strtomember("[" + mid(format(dateadd("yyyy", -5, now()), "Medium Date"), 2 + instr(format(dateadd("yyyy", -5, now()), "Medium Date"), ",")) + "]"),[Measures].[Internet Sales Amount]), format_string = "currency"select {[Measures].[Internet Sales Amount], measures.[5YearBackSales], measures.test1, measures.test2, measures.test3} on 0,[Date].[Calendar].[Month].&[2003]&[11].children on 1from [Adventure Works]