Convert Date (i.e. 8/1/2013) to Text Month (i.e. August)

I have a column of dates in a table and I'd like to convert the value to the month (i.e. as text).

I tried doing this, and although the month appears in the cell, the actual value is still a date.

Please Login or Register  to view this content.

You can use the Format Method

Please Login or Register  to view this content.

I'm sure there is a way to write this shorter but it works this way


Let me know if you find out how to write if shorter