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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment