Forum Discussion
Solved
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 co...
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 š
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 š