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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:56 PM
Points: 267, Visits: 424
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:56 PM
Points: 267, Visits: 424
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