Correction, my apologies, I am using CONVERT(VARCHAR(10),GETDATE(),103). The application is software text messaging which requires the date in dd/mm/yyyy, as far as I know it does not format.