Hey all,

I have a table that contains a field called EffectiveDate which is
displayed in the yyyy-mm-dd format

I'm currently trying to make a seperate column in that same table(using
named calculation) to display a new date format:mm-yyyy
If possible i would also like to change the month number into the month
name using the MonthName function. That way it will look like January,
2005 or January-2005(right now it looks like 2005-01-22)

ps. Im running sql server 2005 and the tables im using have no create
statements as i have imported them into the data source view from our
server.

Thanks in advance.

Found the solution. Right under my nose in the help section too...

DATENAME(mm, EffectiveDate) + ' ,' +DATENAME(yyyy, EffectiveDate)

Cheers