cancel
Showing results for 
Search instead for 
Did you mean: 

Query

Former Member
0 Kudos

Colegas,

Tengo el siguiente query

SELECT

T1.[CodeBars],

T0.[ItemCode] AS Codigo,

T1.[ItemName],

MAX(T0.DocDate)AS Fecha,

MAX(T0.[CalcPrice]) As Costo_de_Compra,

T0.[Warehouse], T0.[TransType]

FROM .[OINM] T0 INNER JOIN .[OITM] T1 ON T1.[ItemCode] = T0.[ItemCode]

WHERE T0.CalcPrice<>0 AND T0.[TransType]=69 AND (T0.[TransValue] <> 0 OR T0.[InQty] <> 0) and T0.[Warehouse] = '[%0]'

GROUP BY T0.[ItemCode], T1.[ItemName], T0.[Warehouse], T0.[TransType], T1.[CodeBars]

¿Cómo hago para que la fecha sea igual o cercana al 31/Dic/09?

Saludos.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hola...

También podrías incorporar otra variable de entrada. Al where, le agregas un

AND T0.DocDate <=

Saludos Cordiales,

former_member188440
Active Contributor
0 Kudos

Checa el formato que tienes configurado con la fecha, pero seria algo asi como


where T0.docdate>='20091231'    o <='20091231'