Hi, I am creating a Report Server Project in BIDS (SQL Server 2008). How do I format dates in this way (October 2010) in the number format field in properties page? Is there a different way of formatting dates? Thanks. Martine

MMM yyyy should do the trick if they are real datesRgds Geoff

Thanks Geoff, The field comes from a query and is calculated as YEAR(poh.OrderDate) * 100 + MONTH(poh.OrderDate) AS OrderMonth. What's the best way to have the report formatted in the right way. Should the query be different or should I write an expression? What should the expression look like? Thanks. Martine

By doing that conversion you are actually creating a string rather than a date If poh.Orderdate is stored as datetime or date in the database, simply return it as is in the query and format as MMM yyyyRgds Geoff

Geoff, Thanks so much! Martine