Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.