Easy question

How do i format a date which is 9/1/2004 as Sept 04

I have tried giving

Format(Fields!GrowthDates.Value,"Y")

but i just get Y and not dates.

Thanks

Regards,

Karen

= Month(Fields!GrowthDates.Value) & " " & Year(Fields!GrowthDates.Value)

Easy question, easy answer. You want to put this in the format expression.

|||

Date.Now.ToString("MMM yy")

|||

Greg,

When i use that expression for 08/01/2004 its give 08 2004 and not Aug 2004 ,,, how can i get it to show Aug 2004

|||

I've never been able to get this function to work, but you would use MonthName. It always returns strange data for me. Maybe someone else can clear this up...

= MonthName(Month(Fields!GrowthDates.Value)) & "-" & Year(Fields!GrowthDates.Value)

Instead of September, I get SepAe0ber 2006

For October, I get OcAober

November - Nove0ber

Strange, huh?

|||

Greg i got it to work

=MonthName(Month(Fields!GrowthDates.Value),true)& " " & Year(Fields!GrowthDates.Value)

True = Abbreviate.

so if my data 08/01/2004 its gonna display Aug 2004

Hope this helps

Regards,

Karen

|||

Why dont you try ="MMM yyyy" in format expression.

Priyank

|||

I tried that in the report but on my X axis instead of the date i get MMM yyy which is of new use.

|||

I get bad abbreviations with that. Some are good but some are still strange...

August - AuA.D.

October OcA

It's almost as if the definitions for the months on my installation of reporting services are wrong.

|||

Priyank Pandey wrote:

Why dont you try ="MMM yyyy" in format expression.

Priyank

That did work, note the case. Thanks!

|||

Its showing up correct on mine....

Regards

Karen

|||

Can you pls mark it as ans.

Thanks!