# Customized columns sort

**URL:** <https://community.mp3tag.de/t/customized-columns-sort/49223>\
**Category:** Support\
**Created:** [June 6, 2020, 3:50pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223 "2020-06-06T15:50:27Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fritz57](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/f/ac91a4/32.png) [@Fritz57](https://community.mp3tag.de/u/Fritz57)\
**Post date:** [June 6, 2020, 3:50pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/1 "2020-06-06T15:50:27Z")

</div>

I added "Date Added" I managed to get the year, but I'd like to get the sort as "yr/mo/date".  
Currently it is sorting as "mo/date/yr".

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [June 6, 2020, 3:58pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/2 "2020-06-06T15:58:54Z")

</div>

Enter something in the column definition property "Sort by", e.g.  
`$regexp(%dateadded%,(\d+)/(\d+)/(\d+),$3/$2/$1)`

---

<div class="post-metadata">

**Author:** ![Fritz57](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/f/ac91a4/32.png) [@Fritz57](https://community.mp3tag.de/u/Fritz57)\
**Post date:** [September 7, 2021, 4:46pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/3 "2021-09-07T16:46:04Z")

</div>

I tried this:  
$regexp(%dateadded%,(\y+)/(\m+)/(\d+),$3/$2/$1)  
But that made no change. What am I getting wrong?

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [September 7, 2021, 4:54pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/4 "2021-09-07T16:54:22Z")

</div>

> [@Fritz57](#):
>
> What am I getting wrong?

You did not follow the rules for sets - have a look at the help on the regular expressions:

> **[Replace with Regular Expression – Mp3tag Documentation](https://docs.mp3tag.de/actions/replace-regexp/)**
>
> Documentation on the Replace with Regular Expression action type that can be performed as Quick Action or as reusable workflow from Action Groups. Mp3tag is the universal Tag Editor.

There is nothing called \y or \m

---

<div class="post-metadata">

**Author:** ![Fritz57](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/f/ac91a4/32.png) [@Fritz57](https://community.mp3tag.de/u/Fritz57)\
**Post date:** [September 7, 2021, 5:15pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/5 "2021-09-07T17:15:53Z")

</div>

Thanks for the link. But my understanding of that is a bit above my pay grade, as it were.  
A little hint?  
Is it anything like this?  
Where 4 represents the year, and 2 the month.

$regexp(%dateadded%,(\d+)/(\d+),$4/$2)

Or am I completely off?

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [September 7, 2021, 5:19pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/6 "2021-09-07T17:19:41Z")

</div>

Have you tried my suggestion?  
the \d simply means "any digit" and the / (slash) is the separator between the digits.  
As you have 3 parts in the date, the expression addresses these 3 parts which are then taken and put into a different order. The parts are numbered sequentially. And as there are no 4 parts, the $4 from your attempt addresses nothing.

---

<div class="post-metadata">

**Author:** ![Fritz57](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/f/ac91a4/32.png) [@Fritz57](https://community.mp3tag.de/u/Fritz57)\
**Post date:** [September 7, 2021, 5:57pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/7 "2021-09-07T17:57:40Z")

</div>

![mp3tag](https://community.mp3tag.de/uploads/default/original/2X/9/9723c9fa2e53b59d0876aa2cbc688c9665219cb1.png)  
not right either, but am I closer?  
For my purposes, Sort could be: yr/mo. I don't need day unless the method does.

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [September 7, 2021, 5:59pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/8 "2021-09-07T17:59:56Z")

</div>

You talked about "dateadded" all the time. In fact you use the file creation date. Do you have any data in the field DATEADDED?  
If not, replace that name in the expression with the real field oder property name.

And as this is a built-in date, you can use a sorting-friendly version of it:  
`%_file_create_datetime_raw%`  
Enter this name in "Sort by".

---

<div class="post-metadata">

**Author:** ![Fritz57](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/f/ac91a4/32.png) [@Fritz57](https://community.mp3tag.de/u/Fritz57)\
**Post date:** [September 7, 2021, 6:29pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/9 "2021-09-07T18:29:15Z")

</div>

![Screen Shot 2021-09-07 at 2.24.10 PM](https://community.mp3tag.de/uploads/default/original/2X/b/b73d544ce88373031813e7370b3e83322cf086f9.png)  
thanks very, ohrenkino. That works.  
I figured I was making more of it than it needed to be.

---

<div class="post-metadata">

**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\
**Post date:** [February 9, 2026, 12:28pm UTC](https://community.mp3tag.de/t/customized-columns-sort/49223/10 "2026-02-09T12:28:38Z")

</div>


