Hi,

I'm trying to change a date format string using a "replace format" rule but
I can't seem to get the format correct or find any docs on it.

I'm reading in MM/DD/YYYY from Peoplesoft and I need to output DD/MM/YYYY.

Can any kind soul give me an idea of the regular expression I need to use?

Here's what i've got so far:-

Destination Attribute("BirthDate")+Replace
First("(dd)/(dd)/(dddd)$","$2-$1-$3",Local Variable("current-value"))

Thanks
Matt