0

Order by desc

I have this in a function

 

let s := this;
let ntxt := "";
for d in (select Orm where Dato > today() - 365 and Heste = s) order by Dato do
ntxt := ntxt + d.Dato + " " + d.Type + " - "
end

now i want it sortet by date descending.. I know SQL and i just add DESC.. Order by dato DESC do.. But it is not working in ninox... Any hints?

 

Henrik

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Maybe this will work: order by number(Dato)*-1

    Steven

    • Henrik_B
    • 3 yrs ago
    • Reported - view

    Tanks.. Worked !