Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display Month and day of week in Expression? Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 2:26 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 301, Visits: 500
Can I use an expression that has..
=Format(Fields!START_DATETIME.Value, "dd") + weekDAY NAME

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

Thanks
Post #1436736
Posted Thursday, March 28, 2013 2:33 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 301, Visits: 500
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
Post #1436743
Posted Friday, March 29, 2013 3:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
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
Post #1436846
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse