# Eval column not sorting properly

**URL:** <https://resource.dopus.com/t/eval-column-not-sorting-properly/60015>\
**Category:** Help & Support\
**Tags:** evaluator\
**Created:** [July 16, 2026, 4:40pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015 "2026-07-16T16:40:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![galaxyhub](https://resource.dopus.com/user_avatar/resource.dopus.com/galaxyhub/32/42793_2.png) [@galaxyhub](https://resource.dopus.com/u/galaxyhub)\
**Post date:** [July 16, 2026, 4:40pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/1 "2026-07-16T16:40:58Z")

</div>

have eval column 'Age' that does not sort properly:

 ![image](https://resource.dopus.com/uploads/default/original/3X/a/1/a10fdc7dabac59ca7f6a61b77940df282800693e.png) ![image](https://resource.dopus.com/uploads/default/original/3X/9/7/970a5c1b659f292b54668beac91649daa8a24442.png)

am using

```auto
if (operation == "sort")
	return Age(modifieddate);

```

but it is not sorting the same as the modified column.

here is the eval column

```auto
<?xml version="1.0"?>
<evalcolumn align="2" attrrefresh="yes" autorefresh="yes" blurrable="no" category="date" customgrouping="no" foldertype="all" header="Age - Days (Modified)" keyword="Agemodified" maxstars="5" namerefresh="yes" nocache="yes" refreshtime="0xea60" reversegroups="no" reversesort="no" supportmarkup="no" title="Age - Days (Modified)" type="0">if (operation == &quot;sort&quot;)
	return Age(modifieddate);

date_now = Now();
when_created = modifieddate;

mins	= Age(when_created, &quot;n&quot;);
hours	= Age(when_created, &quot;h&quot;); // buggy
hours = Abs(mins / 60);
days	= Age(when_created, &quot;d&quot;);
weeks = Age(when_created, &quot;w&quot;);
months = Age(when_created, &quot;m&quot;);
years = Age(when_created, &quot;yyyy&quot;);

return_value = &quot;---&quot;;

if (mins &lt; 0) // for dates set in the future
  {
	return &quot;Future&quot;;
  }
elseif (days &gt;= 365)
  {
    return years &gt; 1 ? years + &quot; years&quot; : years + &quot; year&quot;;
  }
elseif (hours &gt;= 24)
  {
    return days &gt; 1 ? days + &quot; days&quot; : days + &quot; day&quot;;
  }
elseif (hours &gt; 0) 
  {
    return_value = hours &gt; 1 ? hours + &quot; hours &quot; : hours + &quot; hour &quot;;
	mins_left_over = mins - (hours * 60);
    return_value += mins_left_over &gt; 1 ? mins_left_over + &quot; minutes&quot; : mins_left_over + &quot; minute&quot;;
  }
elseif (mins &gt; 0)
  {
    return_value = mins &gt; 1 ? mins + &quot; minutes&quot; : mins + &quot; minute&quot;;
  }
else
  {
    return_value = &quot;0 minutes&quot;;
  }

return return_value;
</evalcolumn>

```

---

<div class="post-metadata">

**Author:** ![lxp](https://resource.dopus.com/user_avatar/resource.dopus.com/lxp/32/33734_2.png) [@lxp](https://resource.dopus.com/u/lxp)\
**Post date:** [July 16, 2026, 6:06pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/2 "2026-07-16T18:06:58Z")

</div>

`Age(modifieddate)` returns days. Try `Age(modifieddate, "s")` to get seconds.

---

<div class="post-metadata">

**Author:** ![galaxyhub](https://resource.dopus.com/user_avatar/resource.dopus.com/galaxyhub/32/42793_2.png) [@galaxyhub](https://resource.dopus.com/u/galaxyhub)\
**Post date:** [July 16, 2026, 6:12pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/3 "2026-07-16T18:12:55Z")

</div>

Still not working ☹ getting this result for

```auto
if (operation == "sort")
	return Age(modifieddate, "s");

```

 ![image](https://resource.dopus.com/uploads/default/original/3X/b/5/b55ce9b468bd53f1afc97b61302edc3f175b7c96.png)

---

<div class="post-metadata">

**Author:** ![Leo](https://resource.dopus.com/user_avatar/resource.dopus.com/leo/32/69732_2.png) [@Leo](https://resource.dopus.com/u/Leo)\
**Post date:** [July 16, 2026, 6:24pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/4 "2026-07-16T18:24:35Z")

</div>

Your column is set to Text type, so it'll do a text sort by default.

This should fix things:

```plaintext
if (operation == "sort")
	return Age(modifieddate, "s") as int;

```

---

<div class="post-metadata">

**Author:** ![lxp](https://resource.dopus.com/user_avatar/resource.dopus.com/lxp/32/33734_2.png) [@lxp](https://resource.dopus.com/u/lxp)\
**Post date:** [July 16, 2026, 6:32pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/5 "2026-07-16T18:32:40Z")

</div>

Actually, my test set works fine even with `Age(modifieddate)`.

 ![image](https://resource.dopus.com/uploads/default/original/3X/f/8/f81a35a36b35b20041ede70d7679c007b31dd00e.png)

🤔

---

<div class="post-metadata">

**Author:** ![Leo](https://resource.dopus.com/user_avatar/resource.dopus.com/leo/32/69732_2.png) [@Leo](https://resource.dopus.com/u/Leo)\
**Post date:** [July 16, 2026, 6:41pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/6 "2026-07-16T18:41:09Z")

</div>

May be luck, since `Age(modifieddate)` will return 0 for all/most of those.

---

<div class="post-metadata">

**Author:** ![galaxyhub](https://resource.dopus.com/user_avatar/resource.dopus.com/galaxyhub/32/42793_2.png) [@galaxyhub](https://resource.dopus.com/u/galaxyhub)\
**Post date:** [July 16, 2026, 6:41pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/7 "2026-07-16T18:41:21Z")

</div>

> [@Leo](#):
>
> ```auto
> if (operation == "sort")
> return Age(modifieddate, "s") as int;
> 
> ```

Awesome, fixed, thanks for looking into it 🙂

---

<div class="post-metadata">

**Author:** ![lxp](https://resource.dopus.com/user_avatar/resource.dopus.com/lxp/32/33734_2.png) [@lxp](https://resource.dopus.com/u/lxp)\
**Post date:** [July 16, 2026, 6:46pm UTC](https://resource.dopus.com/t/eval-column-not-sorting-properly/60015/8 "2026-07-16T18:46:52Z")

</div>

Ah, yes, I hadn't shuffled the files enough 😊
