problem with user defined approval query

[felipe_loyolarodriguez]

Hi

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?

Thanks

Felipe Loyola

[Former Member · Accepted solution]

Hi Felipe Loyola,

Try this:

SELECT DISTINCT 'TRUE' FROM OINV T0

WHERE DATEDIFF(DD,T0.DocDate,GETDATE()) != 0 AND T0.DocNum = '$[$8.0.0\]'

Thanks,

Gordon

[felipe_loyolarodriguez · Accepted solution]

Thanks Gordon

I solved differently

Regards