Thanks for the prompt reply. The issue I get is as follows:

select [dbo].[fnDateFormat](getdate()-3,'dd/mm/yyyy')

-- today is the 11th so the minus 3 is to get a date in single figures.

will return

8/03/2013 and not what I would expect which would be 08/03/2013.

Kevin