Separating Month and Year from a Date

[baltjazz08]

Good afternoon -

I have two date fields in a result set that are currently in the 'mm/dd/yyyy' format that I am trying to convert (not format) to a 'Month-Year' format. So '05/22/2009' should be converted to 'May-2009'. Simply formatting the columns in the available 'M-01' format does nothing, since the underlying date remains. I have other categorization columns that I am trying to group according to month and year, but the day in the date prevents them from grouping properly. Any ideas how to do this?

Thanks,
TJ

 

[Jonmo1]

Welcome to the board...

You'll have to convert them all to the 1st day of the month.
A real date MUST contain a DAY, otherwise it's not a date...

But if you make them ALL the 1st, then you can establish some control with Month and Year...

=A1-DAY(A1)+1

That will convert ANY Date to the 1st of it's respective month/year.


Hope that helps.

 

[VoG]

Try

=TEXT(A1,"mmmm-yyyy")