topic Re: Converter numero em data in QlikView https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759973#M1023244 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 20 Mar 2015 13:36:36 GMT 2015-03-20T13:36:36Z Converter numero em data https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759968#M1023239 <HTML><HEAD></HEAD><BODY><P>Olá a todos,</P><P></P><P>Estou extraindo informações de um banco de dados (Oracle) que trata a data como numero inteiro. Por exemplo: 19/03/2015 ele trata como 9208.</P><P></P><P>O nome do campo é ID_DT. Como faço para transformar esse numero em Ano, Mês e Dia?</P></BODY></HTML> Fri, 20 Mar 2015 12:59:25 GMT https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759968#M1023239 2015-03-20T12:59:25Z Re: Converter numero em data https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759969#M1023240 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use Date(FieldName)</P><P></P><P>Regards</P></BODY></HTML> Fri, 20 Mar 2015 13:01:44 GMT https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759969#M1023240 PrashantSangle 2015-03-20T13:01:44Z Re: Converter numero em data https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759970#M1023241 <HTML><HEAD></HEAD><BODY><P>When do this, return is 16/03/1925 and the correct it is 19/03/2015.</P></BODY></HTML> Fri, 20 Mar 2015 13:10:46 GMT https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759970#M1023241 2015-03-20T13:10:46Z Re: Converter numero em data https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759971#M1023242 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>There is no issue in Date()</P><P>Possible post sample apps.</P><P></P><P>Regards,</P></BODY></HTML> Fri, 20 Mar 2015 13:17:15 GMT https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759971#M1023242 PrashantSangle 2015-03-20T13:17:15Z Re: Converter numero em data https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759972#M1023243 <HTML><HEAD></HEAD><BODY><P>If nothing will work add add 32874</P><P>32874 is 1.1.1990 in most calendar date format.</P><P>(try in Excel)</P><P></P><P>For most calendars 1 is equal to 1.1.1900.</P><P>It looks like Oracle calendar start in 1.1.19<STRONG>90 (which is 1)</STRONG></P><P></P><P>so Date(Your field+32874)</P><P></P><P><IMG __jive_id="81391" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81391_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>The you can create Date,Month,Year using Qlik fucntions</P></BODY></HTML> Fri, 20 Mar 2015 13:29:45 GMT https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759972#M1023243 robert_mika 2015-03-20T13:29:45Z Re: Converter numero em data https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759973#M1023244 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 20 Mar 2015 13:36:36 GMT https://community.qlik.com/t5/QlikView/Converter-numero-em-data/m-p/759973#M1023244 2015-03-20T13:36:36Z