Sort releasedate in the tag panel

Hallo Mp3tag community,

I tag my tracks in releasedate in dd-mm-yyyy.
Can someone help me how to setup the sort options in the tag panel in dd-mm-yyyy.

What exactly do you want to achieve?

Could you show us a screenshot of what you like to see in the Tag Panel?

Maybe you want to sort your content in the File List (not the Tag Panel)?

Provided, you have a column in the file list that shows the data from that field, see
Menu View>Sort by>name of the column for the field.

Please note, that releasedate is probably a user-defined field. If you want to use a standard field, use RELEASETIME

Untitled-1

Sorry guys, new with mp3tag but learning is on the way.

What i like to see is, if i double clik on the filelist release time my files sorting in dd-mm-yyyy from low to high. Now it's only the first 2 numeric is sorting good.

Try to uncheck the "Numeric" check box.

Does this help to sort your files?

And just for completeness:
You can click (once) on the column header in the File List, in your case the word "Release Time".
Then the content will be sorted ascending and after another click descending.

From the already linked documentation:

According to your screenshot, you use
Value: $meta_sep(releasetime,\\)
and
Field: %releasetime%

Where did you get this content for "Value"?
What do you want to achieve with that syntax and command?

I just copy it from the artist Value. What i like to see is that the date sorting good in date-month-year.

Please show us another screenshot from one of your tracks after you have selected it and pressed Alt +T. This shows the View -> Extended Tags popup window and you can see the content of all your tags, including your RELEASETIME content.

Is it really saved as dd-mm-yyyy?

Or is it YYYY-MM-DD?

Untitled-4

Sorry, i'm dutch & and we use dd-mm-yyyy as date.
Maybe is YYY-MM-DD the solutions. I'm gonna test that.

Your screenshot quality is a little bit poor.
I assume, your RELEASETIME content is
07-07-2007
This could be
dd-mm-yyyy
or
mm-dd-yyyy
but for sure you don't have the YYYY in front of this field.

I'm not sure, what exactly you except as sort result.

If I click on a newly added column called Rel-Time it looks like this:
ReleaseTime

How do you want your column sorted?
Could you please give us some examples?

MM-DD-YYYY is the solution, Buy why not DD-MM YYYY

Because Mp3tag starts sorting your values from left to right.
By default, there is no logic to sort "by day in a month in a year."

You have to decide what is most important to you:
a) a date format that you can use in Mp3tag and your player, your smartphone, your car and so on?
or
b) a "natural" sorted column in Mp3tag

For b) you would still have to let us know, how exactly your displayed sort order should looks like.

If you want to just sort your visible column RELEASETIME in the File List of Mp3tag
first by YYYY
then by MM
then by DD
you could use this Sort by:
$right(%RELEASETIME%,4)$mid(%RELEASETIME%,4,2)$left(%RELEASETIME%,2)
image

Example:
31-07-2024

This assumes that your year is always 4 numbers long and at the right side of RELEASETIME.
It assumes, that the position 4 and 5 includes your MM "month" with two numbers.
It assumes, that the first two positions includes your DD "day" with two numbers.

You would have to adjust it to your needs.

Thanks LyricsLover, this what i was looking for.Youre a lifesaver. :partying_face:

As there are mnay ways to skin a cat - you could use a shorter expression in
Sort by: $regexp(%releasetime%,(\d\d)-(\d\d)-(\d\d\d\d),$3-$2-$1)
This expression rearranges dd-mm-yyyy to yyyy-mm-dd

Or even shorter :wink: with
Sort by: $regexp(%releasetime%,(\d+)-(\d+)-(\d+),$3-$2-$1)

image

This would also work for dates like
29-2-2024
or
1-3-2024

That also matches nonsensical stuff like:
1231231-12312513-1215513

If you want to be really precise I'd alter that expression to:

$regexp(%releasetime%,(\d{1,2})-(\d{1,2})-(\d{4}),$3-$2-$1)

And if you also want to account for different writing styles like 29/2/2024 or 29.2.2024, that becomes:

$regexp(%releasetime%,(\d{1,2})[-/.](\d{1,2})[-/.](\d{4}),$3-$2-$1)

grafik

I've used expressions like that to automatically retrieve the year information from bootleg album names where often times you encounter a wild mix of yyyy-mm-dd and mm-dd-yyyy, written in many different ways.

The general idea should be to get a date format
that follows ISO 8601 formats. From the ID3 specs: yyyy-MM-ddTHH:mm:ss (year, "-", month, "-", day, "T", hour (out of 24), ":", minutes, ":", seconds).
So the original date format

does not comply with that ISO and should be modified.
The welcome side effect would be that the ISO compliant date would then sort without any additional statement for the sorting order.