on 03-04-2019 3:17 PM
Estimados Señores,
Por favor solicito vuestro apoyo con sus amplios conocimientos en este mundo de SAP B1:
Tengo el siguiente query y deseo sumar un día a la fecha existente de la tabla T5."TaxDate" por lo tanto solo deseo que se muestre el resultado.
SELECT T0."DocNum" AS "OC SAP", T0."NumAtCard" AS "OC GET", T0."CardCode" AS "Codigo Proveedor", T0."CardName" AS "Proveedor", T0."TaxDate" AS "Fecha OC SAP", T1."BaseDocNum" AS "Sol. Compra", T1."ItemCode", T1."Dscription", T1."Quantity", T1."OpenQty" AS "Pendiente", T1."Price", T1."U_HAK_CANIMP", T1."U_HAK_IMPORT", T1."U_HAK_DETOC", T2."U_HAK_FEPFAB", T2."U_HAK_FERFAB", T2."U_HAK_FEPCON", T2."U_HAK_FERCON", T2."U_HAK_CANTID", T3."U_HAK_FECETA", T3."U_HAK_FECECA", T3."U_HAK_FECEMA", T3."Descript" AS "Embarque", T4."Quantity", T5."TaxDate" AS "Fecha Disponible" FROM OPOR T0 LEFT OUTER JOIN POR1 T1 ON T0."DocEntry" = T1."DocEntry" LEFT OUTER JOIN "@HAK_DETOC1" T2 ON T1."U_HAK_DETOC" = T2."DocEntry" LEFT OUTER JOIN "OOAT" T3 ON T1."U_HAK_IMPORT" = CAST(T3."Number" AS NVARCHAR) LEFT OUTER JOIN PDN1 T4 ON T1."U_HAK_DETOC" = T4."U_HAK_DETOC" LEFT OUTER JOIN OPDN T5 ON T4."DocEntry" = T5."DocEntry"
Hola
si utilizas la función SQL dateadd(dd,1, T5.taxdate)
Un saludo
Agustín
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
9 | |
9 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.