Order By Help

[lockematthewp]

I have a dashboard where I use the Peek function to get a date range. Because of this, I sort my reading dates in descending order (so the Peek function will grab the next highest date).

"ORDER BY [FUEL ASSET] asc, [READING DATE] desc;"

However, When I have two duplicate dates, the dates are backwards. Is there a way to sort by desc, but if they are equal dates to order them backwards?

Thanks,

Matt

[sivakumar1994]

please provide the code or snapshot , to view the issue clearly

[Gysbert_Wassenaar]

Uhm... it doesn't matter how you sort two equal dates...? They're equal so there is no order in which they can be sorted.