How to order GlideRecord query output vy datetime field

[Milan13]

Hello,

I have a problem to sort output of a GlideRecord query by datetime field (Date/Time field).

Even if I convert the date/time field to number value, the orderBy function does not work, any idea why?

Appreciate your help,

Milan

var rec = new GlideRecord('sc_request');
rec.orderBy("u_date_from.getGlideObject().getNumericValue()");
rec.query();
while(rec.next()) {
gs.print(rec.number + ' - ' + rec.u_date_from); }

[Ankur Bawiskar]

Hi Milan,

if that is date/time then it should work as expected

is it not working as expected currently?

Regards
Ankur

[Milan13]

It probably is - there seems to be a data quality issue which confused me a bit...tanks a lot.

[Jaspal Singh · Accepted solution]

Oh Great that things got working & you got to know the issue. Kindly close the thread by marking appropriate answer as correct.

[Ankur Bawiskar]

I am glad to hear your goal has been achieved.

Saying this, I will appreciate if you close this thread, as answered.

Have a great rest of the day.