Many of my tracks have both a DATE and a YEAR field and ideally I'd like to merge them and put the data in
a custom field called DATEBACKUP. Here it should be safe from my DJ mix software that likes to
screw up the DATE and YEAR fields!
My date info is stored as follows:
I would really like them to be in the ISO date format, so, yyyy-mm-dd, and stored in the custom DATEBACKUP field.
I've had a play with reg-ex and browsed the forum for tips but just can't get it.
Can anyone help?