Date Conversion

See more:

DateTime

I am trying to pull data from tables called INVOICE and CUSTOMER. The code is

Create Function MonthOrders (@InvoiceDate datetime)
Returns
    @MonthOrders Table
(
    InvoiceNumber varchar(20),
    InvoiceDate varchar(50),
    CustomerCode varchar(20),
    Customer varchar(30),
    CustomerPhone varchar(12)
)
As
Begin
    While DatePart(mm,'INV_DATE')+DatePart(yyyy,'INV_DATE') = DatePart(mm,@InvoiceDate)+DatePart(yyyy,@InvoiceDate)
        Insert Into @MonthOrders
            Select INV_NUMBER
                ,DatePart(dw,INV_DATE)+ ',' + DatePart(mm,INV_DATE) + DatePart(d,INV_DATE) + ',' + DatePart(yyyy,INV_DATE)
                ,CUSTOMER.CUS_CODE
                ,dbo.FullName(CUS_FNAME, CUS_INITIAL,CUS_LNAME)
                ,CUS_PHONE + '-' + CUS_PHONE
            From INVOICE Left Join CUSTOMER on INVOICE.CUS_CODE = CUSTOMER.CUS_CODE

    Return
End

When I provide the following...

Select 'Orders for January 2006' as Test, *
From dbo.MonthOrders('1-1-2006') ;

I get a date conversion error message...
Conversion failed when converting date and/or time from character string.

What am I doing wrong???