# Converting YYYYDDMM to YYYY.MM.DD
**URL:** https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471
**Category:** Support
**Created:** [January 4, 2015, 5:35pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471 "2015-01-04T17:35:10Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@moomin](https://community.mp3tag.de/u/moomin)
#### Post date: [January 4, 2015, 5:35pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/1 "2015-01-04T17:35:10Z")
Hi
after tagging my songs in mediamonkey with the proper date i refresh mp3tag an the following fields are updated:
Date and Year
My problem is, the field date is populated with DDMM
What i want is to move values in Year and Date over to RELEASETIME in the format YYYY.MM.DD
Also, my current songs have YYYYDDMM in RELEASETIME field. I just moved values in Year and Date over to RELEASETIME field. What expression can i use to convert those to YYYY.MM.DD?
thanks in advance
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [January 4, 2015, 5:38pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/2 "2015-01-04T17:38:24Z")
Use an action of the type "Replace with regular expression" for RELEASETIME
Search string: (\d\d\d\d)(\d\d)(\d\d)
Replace: $1.$2.$3
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [January 4, 2015, 7:52pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/3 "2015-01-04T19:52:10Z")
> [@Chicken Ballsack](#):
>
> ... What i want is to move values in Year and Date over to RELEASETIME in the format YYYY.MM.DD ...
The ID3v2 frame TDRL (tag-field RELEASETIME) is a timestamp field and its format is based on a subset of ISO 8601.
Therefore the separator character "." (dot) seems not be correct.
The full date time format looks like this: "YYYY-MM-DDTHH:MM:SS".
The precision can be reduced by removing as many time indicators as needed, starting at the right edge.
DD.20150104.2152.CET
---
### Author:  [@moomin](https://community.mp3tag.de/u/moomin)
#### Post date: [January 4, 2015, 10:54pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/4 "2015-01-04T22:54:37Z")
Thanks for the help
any way to turn for example: Date Year into Releasetime?
2101 2014 2014.01.21
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [January 5, 2015, 7:33am UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/5 "2015-01-05T07:33:14Z")
> [@Chicken Ballsack](#):
>
> Thanks for the help
> any way to turn for example: Date Year into Releasetime?
> 2101 2014 2014.01.21
DATE=2101
YEAR=2014
RELEASETIME=2014-01-21
Action "Format value"
Field: RELEASETIME
Formatstring: **%YEAR%'-'$right(%DATE%,2)'-'$left(%DATE%,2)**
... or ...
Formatstring: **$regexp(%YEAR%%DATE%,'(\d\d\d\d)(\d\d)(\d\d)','$1-$3-$2')**
DD.20150105.0933.CET
---
### Author:  [@moomin](https://community.mp3tag.de/u/moomin)
#### Post date: [January 8, 2015, 5:11pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/6 "2015-01-08T17:11:54Z")
is it possible to select multiple fields in the Fields field?
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [January 8, 2015, 5:31pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/7 "2015-01-08T17:31:44Z")
No.
Sometimes it it possible to use the %\_tag%. A list of fields is only possible if you want to delete them.
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [January 8, 2015, 7:36pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/8 "2015-01-08T19:36:47Z")
> [@Chicken Ballsack](#):
>
> is it possible to select multiple fields in the Fields field?
What do you want to do?
DD.20150108.2136.CET
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 9, 2026, 12:25pm UTC](https://community.mp3tag.de/t/converting-yyyyddmm-to-yyyy-mm-dd/16471/9 "2026-02-09T12:25:27Z")