Forum Discussion
Helper IIIconvert 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!
I have something like this, so this does work. I didn't want two columns.
Helper IIIHow do I make the data type date? What I'm trying to do is get the Month name to to sort as Jan - Dec. This leaves it as text and sorts alphabetically
sevenhillsSuper User
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!
- Del235
I have something like this, so this does work. I didn't want two columns.
- Idrissshatila