I have data that has been returned from an SQL query that looks like this
2005-07-13 00:00:00.000
Unfortunately it is not recognised as a date so this doesn't work
Code:
Format("2005-07-13 00:00:00.000", "dd/mmm/yyyy")
Is there any short (1 line) way of converting it to 13/Jul/2005?

I can create my own function and use split, but I was wondering if there was a built in way.
Interestingly Excel has no problem formatting it with "dd/mmm/yyyy"