convert date to month name

You could try... and change to the desired format.

 

In the data view,

create two columns. one for month number and other for month name. 

Month Number = Format([YourDate], "MM")

Month Name = Format([YourDate], "MMM")

select the month name column, in the column tools menu, click "Sort by column". Here, by default it will show the month name column. Now, you click "Month number" column. 

In all your visuals of month name, it will be sorted by Month number.

Optional: you can hide the month number column for the users.

Hope it helps!

Hello Del235 ,

can you show us what do you have, the scenario you're working on so we could help.

I have something like this, so this does work.  I didn't want two columns.