Macro for changing date format from US to European

[jammyemma]

Hello, I'm hoping you can help me. I'm working on an enormous document which is full of dates formatted in the US style, as in 'July 12, 2016'. I want to change all of these to the UK style '12 July 2016'.
I've been using a find and replace I found on another forum (find (January) ([0-9]{1,2}),, and replace with \2 \1 but it gives a spacing error which I then have to correct. I also have to do each month separately which is a bit of a faff. So I was wondering if anyone knew of a macro which could do this for me?
All help gratefully received!


Thank you.

[macropod]

You don't need a macro for this - it can be done via a single wildcard Find/Replace, where:
Find = (<[JFMASOND][abceghilmnoprstuvy]{2,8} )([0-9]{1,2}), ([12][0-9]{3}>)
Replace = \2 \1\3
You could, of course, turn the above into a wildcard Find/Replace macro.

[jammyemma]

Brilliant, thanks so much. That works perfectly and is going to make my working life so much easier. Thanks again!