Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Gostaria de criar um campo na tabela abaixo com a data de ontem:
LOAD DISTINCT
APÓLICE AS APOLICE,
REC AS RECIBO,
COMP AS EMPRESA,
RAMO AS CDRAMO,
[DT INI] AS DT_INICIO,
[DT FIM] AS DT_FIM,
VALOR
FROM
[..\..\..\Testes_Rafael\PROJECTOS\RECIBOS POR COBRAR\1. Extração\Ocidental_Recibos_Por_Cobrar.xlsx]
(ooxml, embedded labels, table is OCIDENTAL);
Bom dia, veja se isso lhe atende...
LOAD DISTINCT
APÓLICE AS APOLICE,
REC AS RECIBO,
COMP AS EMPRESA,
RAMO AS CDRAMO,
[DT INI] AS DT_INICIO,
[DT FIM] AS DT_FIM,
VALOR,
date(Today()-1) as DataAnterior //
FROM
[..\..\..\Testes_Rafael\PROJECTOS\RECIBOS POR COBRAR\1. Extração\Ocidental_Recibos_Por_Cobrar.xlsx]
(ooxml, embedded labels, table is OCIDENTAL);
Bom dia, veja se isso lhe atende...
LOAD DISTINCT
APÓLICE AS APOLICE,
REC AS RECIBO,
COMP AS EMPRESA,
RAMO AS CDRAMO,
[DT INI] AS DT_INICIO,
[DT FIM] AS DT_FIM,
VALOR,
date(Today()-1) as DataAnterior //
FROM
[..\..\..\Testes_Rafael\PROJECTOS\RECIBOS POR COBRAR\1. Extração\Ocidental_Recibos_Por_Cobrar.xlsx]
(ooxml, embedded labels, table is OCIDENTAL);