topic Where <Today in Brasil

topic Where <Today in Brasil https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29376#M1540 <HTML><HEAD></HEAD><BODY><P>Bom dia  a todos </P><P></P><P>estou com uma duvida referente a carga. </P><P></P><P>quero deixar meu extrato sempre dia de hoje -1 </P><P></P><P>no quer estou fazendo dessa forma, porem não esta certo alguém consegue me ajudar ?</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">SQL SELECT *</SPAN></P><P>" FROM CNP."FAT_MOVIMENTO_CAPA"</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">where DTA_DOCUMENTO>='01/01/2016' and DTA_DOCUMENTO<"today";</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">STORE FMC into ..\dados\FMC.qvd(qvd);</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Grato desde ja <BR /></SPAN></P></BODY></HTML> Wed, 30 May 2018 11:50:32 GMT davidfagundes 2018-05-30T11:50:32Z Where <Today https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29376#M1540 <HTML><HEAD></HEAD><BODY><P>Bom dia  a todos </P><P></P><P>estou com uma duvida referente a carga. </P><P></P><P>quero deixar meu extrato sempre dia de hoje -1 </P><P></P><P>no quer estou fazendo dessa forma, porem não esta certo alguém consegue me ajudar ?</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">SQL SELECT *</SPAN></P><P>" FROM CNP."FAT_MOVIMENTO_CAPA"</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">where DTA_DOCUMENTO>='01/01/2016' and DTA_DOCUMENTO<"today";</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">STORE FMC into ..\dados\FMC.qvd(qvd);</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Grato desde ja <BR /></SPAN></P></BODY></HTML> Wed, 30 May 2018 11:50:32 GMT https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29376#M1540 davidfagundes 2018-05-30T11:50:32Z Re: Where <Today https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29377#M1541 <HTML><HEAD></HEAD><BODY><P>What database is this? May be this if the database is ORACLE</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>SQL SELECT *</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">"FROM CNP." FAT_MOVIMENTO_CAPA "</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>where DTA_DOCUMENT> = '01/01/2016' and DTA_DOCUMENT < SYSDATE;</STRONG></SPAN></P></BODY></HTML> Wed, 30 May 2018 11:53:22 GMT https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29377#M1541 sunny_talwar 2018-05-30T11:53:22Z Re: Where <Today https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29378#M1542 <HTML><HEAD></HEAD><BODY><P>Olá outra forma de resolver esse problema seria declarar uma variável com o valor do dia atual -1 e usa-lá no Select, segue,</P><P></P><P>LET vHoje = date(Today()-1);</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">SQL SELECT *</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">" FROM CNP."FAT_MOVIMENTO_CAPA"</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">where DTA_DOCUMENTO>='01/01/2016' and DTA_DOCUMENTO< $(vHoje);</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">STORE FMC into ..\dados\FMC.qvd(qvd);</SPAN></P></BODY></HTML> Wed, 30 May 2018 12:01:46 GMT https://community.qlik.com/t5/Brasil/Where-lt-Today/m-p/29378#M1542 giovanneb 2018-05-30T12:01:46Z