# Export sorting

**URL:** https://community.mp3tag.de/t/export-sorting/4375
**Category:** Export
**Created:** [January 24, 2007, 7:18pm UTC](https://community.mp3tag.de/t/export-sorting/4375 "2007-01-24T19:18:41Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![eusty](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/e/2acd7d/32.png) [@eusty](https://community.mp3tag.de/u/eusty)
#### Post date: [January 24, 2007, 7:18pm UTC](https://community.mp3tag.de/t/export-sorting/4375/1 "2007-01-24T19:18:41Z")

</div>

Hi,

Export sorting works fine on all fields _except_ when it involves a date ☹

I've tried sorting by %\_file\_create\_date% and %\_file\_create\_date\_raw% but it only sorts by the day i.e. DD/MM/YYY sorts by DD then MM then YYYY which isn't of much use!!

Is it possible to put the dates in ISO format (YYYY/MM/DD)?

Thanks

Steve

---

<div class="post-metadata">

### Author: ![DetlevD](https://community.mp3tag.de/user_avatar/community.mp3tag.de/detlevd/32/123_2.png) [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [January 24, 2007, 8:24pm UTC](https://community.mp3tag.de/t/export-sorting/4375/2 "2007-01-24T20:24:11Z")

</div>

Hmm, ... thinking ...  
**%\_file\_mod\_datetime\_raw%** should work.  
It returns a sortable number.

|26.03.2005 15:26:37|1111847197|  
|22.07.2006 18:10:55|1153584655|  
|23.01.2007 00:29:16|1169508556|  
|23.01.2007 00:29:20|1169508560|  
|24.01.2007 22:17:56|1169673476|

DD.20070124.2252

---

<div class="post-metadata">

### Author: ![eusty](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/e/2acd7d/32.png) [@eusty](https://community.mp3tag.de/u/eusty)
#### Post date: [January 24, 2007, 8:34pm UTC](https://community.mp3tag.de/t/export-sorting/4375/3 "2007-01-24T20:34:32Z")

</div>

> [@DetlevD](#):
>
> Hmm, ... thinking ...

Yup %\_file\_mod\_datetime% or %\_file\_create\_datetime% doesn't sort correctly, I'm not sure how it's sorted as there is no pattern to it I can see ☹

---

<div class="post-metadata">

### Author: ![eusty](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/e/2acd7d/32.png) [@eusty](https://community.mp3tag.de/u/eusty)
#### Post date: [February 6, 2007, 10:31pm UTC](https://community.mp3tag.de/t/export-sorting/4375/4 "2007-02-06T22:31:18Z")

</div>

> [@DetlevD](#):
>
> Hmm, ... thinking ...  
> **%\_file\_mod\_datetime\_raw%** should work.  
> It returns a sortable number.
> 
> |26.03.2005 15:26:37|1111847197|  
> |22.07.2006 18:10:55|1153584655|  
> |23.01.2007 00:29:16|1169508556|  
> |23.01.2007 00:29:20|1169508560|  
> |24.01.2007 22:17:56|1169673476|
> 
> DD.20070124.2252

Excellent 🙂 %\_file\_create\_datetime\_raw% works just fine.

Steve