I got this popup while trying to use a case statement in an order by clause. Statement works great in ACS. Is there another way to get this done?
I'm trying to order by date but I also have '0001-01-01' dates that I want at the bottom. My order by looks like this.
case when expirationdate = '0001-01-01' then 1 else 0 end,
expirationDate
I'm trying to order by date but I also have '0001-01-01' dates that I want at the bottom. My order by looks like this.
case when expirationdate = '0001-01-01' then 1 else 0 end,
expirationDate
Comment