How to get day and month and day-of-week expression

Question

question

innap9999 asked Oct 22, '13

How to get day and month and day-of-week expression

Hi! In my report (SSRS) I am getting date in "10/21/2013" format, I need to change it to "10/21" and get day-of-week value. I was able to get day-of-week, day and month in separate expression, but don't know how to do it one expression. Thanks

ssrs dates

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-10-22T22:51:03Z

Mister Magoo answered Oct 22, '13

If this is just to format a date, you don't need an expression, you just select the text box in your report, then view the properties and modify the "format" property. You might want something like: ddd MM/dd (for "Tue 22/10") or MM/dd ddd (for "22/10 Tue") See here for more help : [Custom Date and Time Format Strings][1] [1]: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2013-10-23T14:31:38Z

innap9999 answered Oct 23, '13

Thank you. I did not know how to concatenate different parameters, what I did in my report : =Format(Fields!PubDate.Value, "MM")& " / " &Format((Day(Fields!PubDate.Value)) ) & " " & WeekDayName(DatePart("w",Fields!PubDate.Value),True,0) Result is 10/23 Wed

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mister Magoo commented · Oct 23, 2013 at 05:42 PM

So, instead of formatting the date, you added a complicated expression??? Can I ask why you chose that instead of a simple format?

0 ·

innap9999 commented · Oct 23, 2013 at 05:58 PM

I did it before you answered me (I have no experience at all with SSRS), so it's worked and I was happy.

0 ·

question