Forum Discussion
Concatenate Dates Text Error
Hello
I am trying to graph data showing monthly totals. I used the concatenate function to group data into "Month YYYY" format but I can't get the format to be a date, only text (Error: Cannot convert value '' of type Text to type Date).
The resulting graph doesn't give the correct order for months since that column is formatted as text, advice??
walla386
Create another column to sort:MonthYearSort = FORMAT([Date],"yyyymm")Select your Month Year Column and Sort by MonthYearSort Column. This will give you the correct order
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
2 Replies
walla386
Create another column to sort:MonthYearSort = FORMAT([Date],"yyyymm")Select your Month Year Column and Sort by MonthYearSort Column. This will give you the correct order
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
