Dates are tricky. I think that this is because of Locale rules coming into play.
Next: Mon Year (in any order) is not a valid
date . You need all 3 of DD MM YYYY: 01 Jan 2012
Next is where you use the pattern:
Preferences:Adding Books
or
The Metadata Editor (Bulk mode)
I only have luck/skill here
TitleOfTheSerie Volume1 Number1 (out of 3) (2012)
(.+) (\(.+\))\s*\(([\d]{4})\)
Notes: (*not tested)
Group 1 is everything up to the space before the first (
Group 2 is the (out of ... ) pay attention to the escaped ( and )
Group 3 is the 4 digit only Year with the ( ) discarded , again pay attention to the escaped ( )
You are on you own constructing the replacement (used on the Published
destination field) pattern (date in your Locale's format).
01 Jan \3 might do it