REG_EXTRACT - Extract a Date From String in Informatica

To extract date in MM-DD-YYYY or DD-MM-YYYY Format
REG_EXTRACT(employee,'((\d\d)-(\d\d)-(\d\d\d\d))',1)

Note : This does not check valid date
employee dojoutput
asdf12-04-19884sadf12-04-1988
asdf12-04-198813-04-198812-04-1988
asdf12-04bc-1988Empty String
asdf12-99-19884sadf12-99-1988