problem with user defined approval query
Sorry me for my english
I have a problem with approval query
DECLARE @DocDate DATETIME SET @DocDate = (SELECT $[OINV.DocDate]) IF (DATEDIFF(DAY,@DocDate,GETDATE())) != 0 BEGIN SELECT DISTINCT 'TRUE' END
the query works with the previous invoices, but today's invoices show me a error colud not commit transaction
Can Help me?