topic Re: Como Formatar Dia, Mes, Ano in Brasil https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899962#M30219 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">t1:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">load Date(Date#(Data,'YYYYMMDD')) as Data inline</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">[ Data</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">20140322</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">20140323</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">]</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">;</P></BODY></HTML> Fri, 08 May 2015 11:56:02 GMT Clever_Anjos 2015-05-08T11:56:02Z Como Formatar Dia, Mes, Ano https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899960#M30217 <HTML><HEAD></HEAD><BODY><P>Pessoal boa noite.</P><P>Como formatar o Dia, Mes e Ano para um campo de data que vem da seguinte forma 20140322?</P><P></P><P>Usei o day(), month() e year() mas os dados não ficam ok nos campos.</P></BODY></HTML> Fri, 08 May 2015 00:21:47 GMT https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899960#M30217 2015-05-08T00:21:47Z Re: Como Formatar Dia, Mes, Ano https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899961#M30218 <HTML><HEAD></HEAD><BODY><P>t1:</P><P>load * inline</P><P>[ Data</P><P>20140322</P><P>20140323</P><P>]</P><P>;</P><P>t2:</P><P>load</P><P>Left(Data,4) as Year,</P><P>mid(Data,5,2) as Month,</P><P>Right(Data,2) as day</P><P></P><P></P><P>Resident t1;</P><P>drop table t1</P><P></P><P><IMG alt="2015-05-08 05_35_25-Edit Script [C__Users_Katarzyna_Desktop_qvw_dasa.qvw_].png" class="jive-image image-1" src="/legacyfs/online/85992_2015-05-08 05_35_25-Edit Script [C__Users_Katarzyna_Desktop_qvw_dasa.qvw_].png" style="height: auto;" /></P></BODY></HTML> Fri, 08 May 2015 04:34:37 GMT https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899961#M30218 robert_mika 2015-05-08T04:34:37Z Re: Como Formatar Dia, Mes, Ano https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899962#M30219 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">t1:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">load Date(Date#(Data,'YYYYMMDD')) as Data inline</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">[ Data</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">20140322</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">20140323</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">]</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">;</P></BODY></HTML> Fri, 08 May 2015 11:56:02 GMT https://community.qlik.com/t5/Brasil/Como-Formatar-Dia-Mes-Ano/m-p/899962#M30219 Clever_Anjos 2015-05-08T11:56:02Z