BUEN DIA
estimados tengo este comando de crystal y esto agregando esta leyenda para que me traiga la hora de creación del documento pero me sale error
LEFT (OINV."DocTime", LENGTH(OINV."DocTime")-2)||':'||RIGHT (OINV."DocTime",2) AS "DocTime", OINV."CreateDate",
SELECT OINV."DocEntry",
OINV."U_SEI_TIP_CAM",
OINV."U_SEI_VAL_DOL",
OINV."U_SEI_NOTA",
SN."VatIdUnCmp",
OINV."DocDate",
OINV."CardName",
OINV."DocDueDate",
OINV."DocNum",
OINV."U_SEI_TIP_CAM",
SN."Phone1",
INV1."ItemCode",
INV1."Weight1",
INV1."Dscription",
INV1."Quantity",
SN."Address",
P."Name",
SN."City",
OINV."DocTotal",
OINV."U_SEI_NOTAF",
OITM."SalUnitMsr",
OCTG."PymntGroup",
INV1."LineTotal" + INV1."VatSum" AS "Precio",
INV1."Currency",
V."SlpName",
V."SlpCode",
INV1."PriceBefDi",
INV1."PriceAfVAT",
INV1."LineNum"+1 as "Linea"
**LEFT (OINV."DocTime", LENGTH(OINV."DocTime")-2)||':'||RIGHT (OINV."DocTime",2) AS "DocTime", OINV."CreateDate",**
FROM "{?Schema@}".OINV
INNER JOIN "{?Schema@}".OCRD AS SN ON SN."CardCode" = OINV."CardCode"
INNER JOIN "{?Schema@}".OCRD ON OINV."CardCode" = OCRD."CardCode"
INNER JOIN "{?Schema@}".OCTG on OCRD."GroupNum" = OCTG."GroupNum"
INNER JOIN "{?Schema@}".OCRY AS P ON P."Code" = SN."Country"
INNER JOIN "{?Schema@}".OSLP AS V ON V."SlpCode" = OINV."SlpCode"
INNER JOIN "{?Schema@}".INV1 ON INV1."DocEntry" = oinv."DocEntry" AND OINV."DocSubType" != 'DN'
INNER JOIN "{?Schema@}".OITM on INV1."ItemCode" = OITM."ItemCode"
WHERE
(CASE WHEN (SELECT IFNULL(J0."U_SOL_imprime_lista",'S') FROM "{?Schema@}".OINV J0 WHERE J0."DocEntry"=OINV."DocEntry")='N'
AND INV1."TreeType" = 'I' THEN 'NN' ELSE 'SS' END) = 'SS'
AND OINV."DocEntry" = {?Dockey@}
gracias
