I have a stored procedure that requires a date parameter. It is called from from within an access function. The results from the Immediate window return:
Item not found in this collection.
I am assuming that means there are no records found. In order to eliminate complexities, I have tested the stored procedure form the SQL Server query editor and I am unsure what the correct date format required. Here is the stored procedure or the editor that I am executing from:
USE [PSEOC IBIX Import]
DECLARE @return_value int
EXEC @return_value = [dbo].[Get_IBIX_Success_Totals_By_Date]
@ActualCostDate = '3/2/2011 12:00:00 AM'
SELECT 'Return Value' = @return_value