Hi All,

Can anyone please advise on a formula which would format the date and time.

Current string are like below:
2/22/17 8:10 AM
3/1/17 1:28 PM
The first field in date is the month and is 1 or digits and the same applies to the time hour field which is always labelled am or pm.

I would like this to be:
22/02/2017 08:10
01/03/2017 13:28
Just for clarity the source field is m/d/yy h:mm and I would like it to be dd/mm/yyyy hh:mm

Thanks in advance.