Where do you want to convert the date format - SSRS or Database?

If the latter I strongly recommend against it. Date formatting should be done at the front end side (e.g. SSRS), especially, if the target format cannot be achieved using the standard CONVERT function.

In the scenario you described a concatenation of various CONVERT functions together with DATENAME function would be required.