Friday, March 9, 2012

Get the month from a date field

Hi,

There's probably a really simple asnwer to this but i cant seem to find it.

I have a date field and i want to display just the month in words.

At the moment i have

DatePart(m,PressreleaseDate) AS stMonth

but that returns a value of 1-12, i want January to December

can anyone help

Regards,

LukeNevermind i've worked it ut

Datename(month,([PressreleaseDate])) as 'MonthName'

Easy!

No comments:

Post a Comment