This content has been marked as final. Show 2 replies
I am trying to get two fields in the YYYY-MMM formatting to sort newest to oldest without any luck. I format them as Date(MyDate,'YYYY-MMM') but when I display it in a chat with a simple count of the data it duplicates the Year/Months...
I also tried year(MyDate)&'-'&month(MyDate) after doing an "Order By' in the table below.... this works... but I have two dates I am doing this for. It of course only orders by the first one I list.
Is there a sort expression I can use in the chart itself to sort by a date field? Sort By---> Expression----> Desc----> and maybe =MyDate or something?