>DD/MM/YYYY 12:00:00 AM needs to be converted to DD/MM/YY 12:00 AM
This one can be handled using exactly the same kind of concat/substring logic as the previous problem
>Because some of the dates are 7/12/2006 and then 10/12/2006 the position may change.
This makes it more difficult. In XSLT 2.0 you can use regular expressions to analyse the strings. In 1.0, you're confined to a more limited set of functions such as substring-before and substring-after. It's tedious, for example to extract the second component you have to do
substring-before(substring-after(., '/'), '/')
but it's still possible. You can use format-number() to force a number to exactly two digits.
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference