IPB

Welcome Guest ( Log In | Register )

> Notice!

Please take a minute to check our Frequently Asked Questions. Use Search to reveal possible related topics.

Also make sure you've read the Forum Guidelines before posting in this forum.

 
Reply to this topicStart new topic
> Date format conversion, iTunes YEAR format -> DD-MM-YYYY
Solance
post Apr 21 2017, 11:18
Post #1


Member


Group: Full Members
Posts: 12
Joined: 21-April 17
Member No.: 23336
Mp3tag Version: 2.81



Looking for a little help.
Need to take date data from (YEAR) field in (YYYY-MM-DDTHH:MM:SS) format and move it to (RELEASETIME) field in (DD-MM-YYYY) format.
Something like "2017-04-16T07:00:00Z" to "16-04-2017"
Any advice? huh.gif
Go to the top of the page
 
+Quote Post
ohrenkino
post Apr 21 2017, 12:06
Post #2


Member


Group: Full Members
Posts: 9228
Joined: 9-December 09
From: Norddeutschland / Northern Germany
Member No.: 11458
Mp3tag Version: 2.85



ZITAT(Solance @ Apr 21 2017, 12:18) *
Looking for a little help.
Need to take date data from (YEAR) field in (YYYY-MM-DDTHH:MM:SS) format and move it to (RELEASETIME) field in (DD-MM-YYYY) format.
Something like "2017-04-16T07:00:00Z" to "16-04-2017"
Any advice? huh.gif

The YEAR field looks a lot like the proper format for field RELEASETIME. I would not change it at all.
RELEASETIME has both: the day and the hour. And it needs it in the sequence of year-month-day.

So, if you change the order then it might be that you get suprising results esp. when sorting as you then get all first days of all months first, then the second and so on.l


--------------------
42 - wie war die Frage / what was the question / quelle était la question
Go to the top of the page
 
+Quote Post
DetlevD
post Apr 21 2017, 12:36
Post #3


Member


Group: Full Members
Posts: 6718
Joined: 26-May 06
From: Wuppertal, Germany, Planet Earth
Member No.: 3194
Mp3tag Version: 2.85



QUOTE (Solance @ Apr 21 2017, 12:18) *
Looking for a little help. ...

Do have a look into ... e. g. ...
https://forums.mp3tag.de/index.php?showtopic=19540
... and follow the ISO 8601 date time standard format,...
especially for the tagfield RELEASETIME.

DD.20170421.1336.CEST


--------------------
* Beyond that, don't ask, when you don't know what to do with the answer. *
♥ home is where the heart is ♥
Go to the top of the page
 
+Quote Post
Solance
post Apr 21 2017, 13:43
Post #4


Member


Group: Full Members
Posts: 12
Joined: 21-April 17
Member No.: 23336
Mp3tag Version: 2.81



ok so this (DD-MM-YYYY) format is "broken" for (RELEASETIME) field.
but it always could be added in (COMMENT) or somewhere else, so is there a way to convert date somehow?
Go to the top of the page
 
+Quote Post
ohrenkino
post Apr 21 2017, 13:51
Post #5


Member


Group: Full Members
Posts: 9228
Joined: 9-December 09
From: Norddeutschland / Northern Germany
Member No.: 11458
Mp3tag Version: 2.85



ZITAT(Solance @ Apr 21 2017, 14:43) *
ok so this (DD-MM-YYYY) format is "broken" for (RELEASETIME) field.
but it always could be added in (COMMENT) or somewhere else, so is there a way to convert date somehow?

Create an action of the type "Format value" for COMMENT or somewhere else.
Format string: $regexp('2017-04-16T07:00:00Z',(\d+)-(\d+)-(\d+)T.*,$3-$2-$1)

Instead of the '2017-04-16T07:00:00Z' part of the expression set the source field name, e.g. %year%.


--------------------
42 - wie war die Frage / what was the question / quelle était la question
Go to the top of the page
 
+Quote Post
Solance
post Apr 21 2017, 15:08
Post #6


Member


Group: Full Members
Posts: 12
Joined: 21-April 17
Member No.: 23336
Mp3tag Version: 2.81



QUOTE (ohrenkino @ Apr 21 2017, 15:51) *
Create an action of the type "Format value" for COMMENT or somewhere else.
Format string: $regexp('2017-04-16T07:00:00Z',(\d+)-(\d+)-(\d+)T.*,$3-$2-$1)

Instead of the '2017-04-16T07:00:00Z' part of the expression set the source field name, e.g. %year%.

perfect, exactly what I needed, problem solved.
thanks a lot! laugh.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 19th November 2017 - 20:43