https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569580#M56466 <P>Boa tarde,</P><P>tente usar a função&nbsp;<SPAN><STRONG>Timestamp()</STRONG> certamente suprirá sua necessidade.</SPAN></P><P><SPAN><A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Timestamp.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Timestamp.htm</A></SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 15 Apr 2019 18:14:31 GMT danilostochi 2019-04-15T18:14:31Z https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569571#M56465 <P>Veja que na imagem ele não está trazendo a data e também a hora também não está vindo.</P><P>Preciso corrigir o script abaixo:</P><P>Script:</P><P><BR />Date(Date(Date#(@3, 'YYYYMMDDHHMM'), 'DD/MM/YYYY hh:mm')) AS DATA,</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-04-15_14-56-15.png" style="width: 207px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/10230iFBB09684057C5561/image-size/large?v=v2&amp;px=999" role="button" title="2019-04-15_14-56-15.png" alt="2019-04-15_14-56-15.png" /></span></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>@1</TD><TD>@2</TD><TD>@3</TD><TD>@4</TD><TD>@5</TD></TR><TR><TD>*Placa</TD><TD>AAAA/MM/DD HH/MM</TD><TD>AAAA/MM/DD HH/MM</TD><TD>CARRO</TD><TD>Tempo</TD></TR><TR><TD>NIJ1925</TD><TD>201904151210</TD><TD>201904151211</TD><TD>CARRO</TD><TD>1 min.</TD></TR><TR><TD>OVW2237</TD><TD>201904151241</TD><TD>201904151245</TD><TD>CARRO</TD><TD>4 min.</TD></TR></TBODY></TABLE> Mon, 15 Apr 2019 17:59:42 GMT https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569571#M56465 Ribeiro 2019-04-15T17:59:42Z https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569580#M56466 <P>Boa tarde,</P><P>tente usar a função&nbsp;<SPAN><STRONG>Timestamp()</STRONG> certamente suprirá sua necessidade.</SPAN></P><P><SPAN><A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Timestamp.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Timestamp.htm</A></SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 15 Apr 2019 18:14:31 GMT https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569580#M56466 danilostochi 2019-04-15T18:14:31Z https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569593#M56467 <P>Timestamp(Timestamp#(@3,'YYYYMMDDhhmm'),'DD/MM/YYYY hh:mm') as NewTime,</P><P>Parabéns pela paciência e competência</P><P>Obrigado</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-04-15_15-36-30.png" style="width: 545px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/10236i3CD9AD9F1A59CA38/image-size/large?v=v2&amp;px=999" role="button" title="2019-04-15_15-36-30.png" alt="2019-04-15_15-36-30.png" /></span></P> Mon, 15 Apr 2019 18:38:08 GMT https://community.qlik.com/t5/Brasil/Formatar-Texto-em-Data-com-hora-e-Minutos/m-p/1569593#M56467 Ribeiro 2019-04-15T18:38:08Z