That could be the problem, they should be char according to your SP

>Hi,
>date not date time
>
>>Andy,
>>
>>What data type is thisform.startdate.value and thisform.enddate.value?
>>
>>
>>
>>>I have 3 parameters I am trying to pass to a stored procedure
>>>They are date fields in the parameters, not date time.
>>>The SP variables are string.
>>>
>>>Is this the correct syntax in Foxpro 9?
>>>I am not getting a cursor to be generated.
>>>The SP works when I enter 01/01/2009 and 02/01/2009 in QA
>>>
>>>ldStartDate={}
>>>ldEndDate={}
>>>ldStartDate=thisform.startdate.value
>>>ldEndDate=thisform.enddate.value
>>>
>>> lcSQLCMD="exec get_invoices ?ldStartDate,?ldEndDate"
>>> SQLEXEC(gnConnect,lcSQLCMD,'jobcost')
>>>
>>>
>>>the parameters in the SP are this
>>>
>>>Alter PROCEDURE get_invoices
>>> @ldStartDate Char(12) = '',
>>> @ldEndDate Char(12) = ''
>>>AS