Display Month and day of week in Expression?

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  March 28, 2013 at 2:26 pm

  #275785

  Can I use an expression that has..

  =Format(Fields!START_DATETIME.Value, "dd") + weekDAY NAME

  example 3/28/2013 = '28 - Thr'

  Thanks

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  March 28, 2013 at 2:33 pm

  #1601865

  so I got it workiung with

  =Format(Fields!START_DATETIME.Value, "dd") +" " + WeekDayName ( WeekDay( Fields!START_DATETIME.Value ) )

  but can i GET Fri instead of Friday?

  and or on 2 lines like 1

  Fri

• THE-LIP

  SSChasing Mays

  Points: 655

  More actions

  March 29, 2013 at 3:15 am

  #1601946

  You can use below expression:

  ="Today is: "& today &" Output: "& day(today)&" - "& WeekDayName(DatePart(DateInterval.Weekday,today),True,FirstDayOfWeek.System)

  And output will look like this

  Today is: 3/29/2013 Output: 29 - Fri