casting integer to month

Hi,

in the database that we use for learning reporting services a month is saved as an integer in a column. In the report I would like to have the month fully written istead of the numbers 1 to 12. Is this possible with the CAST function or the CONVERT function, I can't find the exact information in the msdn.

greetings

Hi,

as far as I know, there is only DATENAME which produces the name of the Month, perhaps you make a function out of that:

CREATE FUNCTION MonthName
(
@.Month TINYINT
)
RETURNS VARCHAR(20)
AS
RETURN (Select DATENAME(mm,DATEADD(dd,-1,DATEADD(mm,@.Month,0))))

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Creating a new function would do the trick indeed but I am working in a limited version of Visual Studio that only allows us to do reporting services...
|||I tried to use the function DATENAME in the field where the month should appear. 'Fields!maand.Value' is the value from the database.

=DATENAME(mm,DATEADD(dd,-1,DATEADD(mm,Fields!maand.Value)))
|||oh and it didn't worked ;)
|||Oh it's easy
the function is:

=MonthName(Fields!maand.Value)
you can place it an your tabel in your layout
it's a visual basic function apparently
|||My post was TSQL syntax, if you want to format that inyour code (VBScript) you have to do something like =FORMAT("MM",yourdate) or =MONTH(Yourdate), sorry but I don′t have the syntax right in my mind, perhaps you can check the help file form the report builder.

HTH, Jens Suessmeyer.