deepeshdhake (10/2/2012)
I have the date time field. I want extract only Month and the year. How can I do the same.Current format of the field is "10/01/2012 hh:mm:ss"
Need to convert to "October 2012"
I want to do these changes in SSRS.
Assuming your source data field is a datetime datatype and you don't want the day, you could do something like:
=Format(Fields!YourDate.Value, "MMMM") & " " & CStr(Year(Fields!YourDate.Value))
HTH,
Rob
[font="Tahoma"]*I don't have SSRS open as I type this, so please double check my memory to make sure it works as you wish[/font]