Hi,

I have a procedure in sql and i am calling it using Advanced SQL Like -

/* %LogicalDatabase%=GetLogicalDatabase({prj_hrs}) */

Select {prj_hrs}.* from {prj_hrs}

EXEC @return_value =  [prjdb].[dbo].[UpDate_EmployeeHours_Status]
    @emp_id,
    @wk_end_dt,
    @updt_id,
    @status

Input variables types - 

emp_id = Text

wk_end_dt = DateTime

updt_id = user identifiers

status = integer 

When i am calling it, i am getting bellow error.

"Error in Advanced query ApproveTimesheet.the string was not recognized as a valid datetime. there is an unknown word starting at index 0"

Thanks

Jitendra