formatting custom tags

[DetlevD]

@jaketh

... I'm using Guess Values "%_file_create_date%": %month_added%/%day_added%/%year_added% to create tags for each value so I can sort down quickly by year or month. ... I tried using a few functions to achieve the reformat and force leading zeros on month and day ... could anyone point me in the right direction?

Mp3tag offers different ways to reach the goal. Here is one.
For a given DateTime string, in the following example, having international ISO 8601 format, it is rather easy to split the string into each subvalue into a Mp3tag variable.

For example ...

Action "Format value" Field: TMP_DT_CREATED Formatstring: $replace(%_file_create_datetime%,'-','\\\\',' ','\\\\',':','\\\\') ... gives ... TMP_DT_CREATED(0)..TMP_DT_CREATED(5) %_file_create_datetime% is '2014-09-21 12:34:56' $meta(TMP_DT_CREATED,0) is '2014' $meta(TMP_DT_CREATED,1) is '09' $meta(TMP_DT_CREATED,2) is '21' $meta(TMP_DT_CREATED,3) is '12' $meta(TMP_DT_CREATED,4) is '34' $meta(TMP_DT_CREATED,5) is '56'

If your computer DateTime setting differs from the international standard, then you have to adapt the proposal to your needs.

See also ...
Turn D/M/YYYY into YYYY/MM/DD

DD.20140921.1056.CEST