Datatype conversion

svga · Post by **svga** » Mon Oct 13, 2008 1:03 am

Hi,

I have problem in converting char string to datetime datatype.The macro Datetimestamp is being passed as a user status to the next job where i am deleting the record from SQL table if the Extrctdte(One of the column in the table) is equal to Datetimestamp.Here i am getting an error as "Syntax error converting datetime from character string". Please help me to convert the string into datetime format.

chulett · Post by **chulett** » Mon Oct 13, 2008 7:50 am

Which macro, exactly? There isn't one called "Datetimestamp".