ssrs dynamically get Month name in the format MMMYY - Very urgent

• D.DHAMO

  Mr or Mrs. 500

  Points: 506

  More actions

  July 5, 2012 at 8:05 am

  #392667

  Hi all,

  Currently use below code get Month number

  how can i get Month name in the format MMMYY usinf similar function

  Any help......

  Public Function GetColumnHeading(ByVal x As Integer)

  Dim WeeksArr As New System.Collections.ArrayList()

  Dim i As Long

  Dim CurrentWeek As Long

  CurrentWeek = DatePart(DateInterval.MONTH, System.DateTime.Now)

  For i = 1 To 12

  WeeksArr.Add(-1 + (i + CurrentWeek - 1) Mod 12)

  Next

  Return WeeksArr(x)

  End Function

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  July 5, 2012 at 8:37 am

  #1509153

  Could use an expression

  =FORMAT(Today(),"dd/MMMM/yyyy")

  Can experiment with the string format, just remember that capital M is month and lower m is minutes.