# Date/Time sort puts 12a (00:00) after 1a (01:00)
**URL:** https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216
**Category:** Support
**Created:** [February 5, 2022, 4:37am UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216 "2022-02-05T04:37:48Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@dragon9874](https://community.mp3tag.de/u/dragon9874)
#### Post date: [February 5, 2022, 4:37am UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216/1 "2022-02-05T04:37:48Z")
This is a fairly simple explanation, sorting by Date/Time puts 12am (00:00) after 1am (01:00). This is logical from a numbers perspective, but not time. I scoured the existing articles, but didn't find a match (nothing even close). I've also downloaded the latest version (i was on v3.11), which had the same result. The Dev build was the same v3.12.0.0, so i didn't test that. It would seem that either 12a should be represented as 00, or add AM/PM to the Date/Time sort criteria? But i'll leave all the magic to 'Florian the Magician'!
😉
thx for all that you do!!
web
---
### Author:  [@poster](https://community.mp3tag.de/u/poster)
#### Post date: [February 5, 2022, 6:22am UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216/2 "2022-02-05T06:22:17Z")
How did you define the "Created" column? Is it the file creation date of the operating system?
Then you need to change `Sort by` in the definition of the column to `%_file_create_datetime_raw%`.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [February 5, 2022, 7:59am UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216/3 "2022-02-05T07:59:45Z")
> [@dragon9874](#):
>
> I scoured the existing articles
The search words "date create sort" produce e.g. this thread
> [@Sort by creation date](https://community.mp3tag.de/t/sort-by-creation-date/12108/3):
>
> Yes: create a new column (rightclick on the column header, then New). Enter as value %\_file\_create\_date% or %\_file\_create\_datetime% (depending on your likings for details). These Fields can also be found in the list of information fields that is accessible via the arrow button next to the entry field.
which shows the solution shown by @poster.
> [@dragon9874](#):
>
> This is logical from a numbers perspective, but not time
MP3tag does not evaluate what kind of data gets delivered in a particualr field. You would have to take care to get a representation that you like.
That is why you have to set the attriubutes for a column like field, value, sort by and numerical.
---
### Author:  [@dragon9874](https://community.mp3tag.de/u/dragon9874)
#### Post date: [February 19, 2022, 3:37pm UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216/4 "2022-02-19T15:37:18Z")
thx for the find ohrenkio... and help ohrenkino (& Poster!)! 🙂 i'll give it a shot... sounds like it should work w/o issue. thx again to the both of you!! 🙂
---
### Author:  [@dragon9874](https://community.mp3tag.de/u/dragon9874)
#### Post date: [February 19, 2022, 4:26pm UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216/6 "2022-02-19T16:26:44Z")
3rd time was a charm! kept missing the 'raw' at the end (thx @poster )... ugh. 😉 had to take my DUNCE cap off to see it. 🙂 gotta remember this is so highly customizable, i just need to dig a bit deeper sometimes to find a way to do whatever it is i need to do. everyone's different, mp3tag accounts for that. one of the MANY things that make this app so awesome!
thx all, as always... EXTREMELY helpful!
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [March 21, 2022, 4:27pm UTC](https://community.mp3tag.de/t/date-time-sort-puts-12a-00-00-after-1a-01-00/56216/7 "2022-03-21T16:27:24Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.