CREATE FUNCTION [dbo].[f_format_date] (@dateField varchar(40)
                                                        , @format varchar(30) = NULL)
RETURNS varchar(20) AS
BEGIN
 IF @format = 'default'
  SET @format = 'YYYYMMDD'
 DECLARE @result varchar(20)
 IF @format = 'Mon-YY'
  set @result =  SUBSTRING(DATENAME(month, @dateField),1,3)  + '-' + SUBSTRING(DATENAME(yyyy, @dateField),3,2)
 IF @format = 'YYYYMMDD'
  set @result =  CAST(DATEPART(yyyy, @dateField) AS CHAR(4)) +
                 RIGHT('0' + RTRIM(CAST(DATEPART(mm, @dateField) AS CHAR(2))), 2) +
                 RIGHT('0' + RTRIM(CAST(DATEPART(dd, @dateField) AS CHAR(2))), 2)
 IF @format = 'MM/DD/YY'
  set @result =  RIGHT('0' + RTRIM(CAST(DATEPART(mm, @dateField) AS CHAR(2))), 2)  + '/' +
    RIGHT('0' + RTRIM(CAST(DATEPART(dd, @dateField) AS CHAR(2))), 2) + '/' +
    CAST(SUBSTRING(CAST(DATEPART(yyyy, @dateField) AS CHAR(4)), 3,2) AS CHAR(2))
 IF @format = 'MM/DD/YYYY'
  set @result =  RIGHT('0' + RTRIM(CAST(DATEPART(mm, @dateField) AS CHAR(2))), 2)  + '/' +
    RIGHT('0' + RTRIM(CAST(DATEPART(dd, @dateField) AS CHAR(2))), 2) + '/' +
    CAST(DATEPART(yyyy, @dateField) AS CHAR(4))
 RETURN @result
END