When I am working with reports, this is what every time I am looking for. Everyone gives date on the report as input, and I want display the month name on the report instead of month index [1-12]. So, how to do it?
please use the below script to get the name of the month by month index.
please use the below script to get the name of the month by month index.
DateName(month, convert( datetime, '2007-' + cast(month(getdate()) as varchar(2)) + '-01', 120))
Thanks.
ReplyDeleteThis is what I am exctly looking for
Thanks for the nice post.
ReplyDeleteThanks a ton....
ReplyDeleteIt was very helpful....
What's wrong with
ReplyDeleteDateName(month, getdate())