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:
The Metadata Editor (Bulk mode)
I only have luck/skill here
TitleOfTheSerie Volume1 Number1 (out of 3) (2012)
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