I've a column type "datetime" that reads 09/23/2011 12:00:00 AM, need to show only the month and day portion seprated by "/" or "-".
There're 2 ways to do it in SSRS:
1-the easiest way :) and the right one too...
=Month(Fields!Tuesday.Value) & "/" & Day(Fields!Tuesday.Value)
2-the long fiasco way ! I was just fooling around !!
=StrReverse(Replace(StrReverse(left(Fields!Sunday.Value).ToShortDateString,5)),"/","",1,1))
It's your call...
No comments:
Post a Comment