Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Return weekday name

Author  Topic 

kdnichols
Posting Yak Master

232 Posts

Posted - 2006-11-13 : 15:33:32
Hello Again,

I know which function to use in an expression.

It is:

=FormatDateTime(Fields!DateReceived.Value,1)

Can someone help me get just the weekday name to return in this. I want to use this as an expression.

TIA

Kurt

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-13 : 16:02:05
Add a new column in either the stored procedure or in the view that returns data to your application.
The new column should consist of

SELECT <all other columns>, DATENAME(dw, DateReceived)
FROM ....

Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -