topic Date from Excel in QlikView https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724321#M1059130 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a excel sheet with lots of data - all data have a date collumn "yyyy-mm-dd".</P><P></P><P>When i import this collumn to Qlikview i get wierd formation. I only get a number string like "41814".</P><P></P><P>So how can i do to translate this in to its real value "2014-07-26"?</P><P></P><P>Thanks!</P><P></P><P>//Erik</P></BODY></HTML> Tue, 30 Sep 2014 08:07:38 GMT 2014-09-30T08:07:38Z Date from Excel https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724321#M1059130 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a excel sheet with lots of data - all data have a date collumn "yyyy-mm-dd".</P><P></P><P>When i import this collumn to Qlikview i get wierd formation. I only get a number string like "41814".</P><P></P><P>So how can i do to translate this in to its real value "2014-07-26"?</P><P></P><P>Thanks!</P><P></P><P>//Erik</P></BODY></HTML> Tue, 30 Sep 2014 08:07:38 GMT https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724321#M1059130 2014-09-30T08:07:38Z Re: Date from Excel https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724322#M1059131 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P>Date(YourDateFiled,'YYYY-MM-DD') as Date.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 30 Sep 2014 08:09:40 GMT https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724322#M1059131 ashfaq_haseeb 2014-09-30T08:09:40Z Re: Date from Excel https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724323#M1059132 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Go to Number tab-&gt;Number Format Setting-&gt;Select date format. mention format as per requirement.</P><P></P><P>Regards</P></BODY></HTML> Tue, 30 Sep 2014 08:13:34 GMT https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724323#M1059132 PrashantSangle 2014-09-30T08:13:34Z Re: Date from Excel https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724324#M1059133 <HTML><HEAD></HEAD><BODY><P>Hi Erik,</P><P></P><P>The answer of Ashfaq it's right.</P></BODY></HTML> Tue, 30 Sep 2014 08:14:16 GMT https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724324#M1059133 sorrakis01 2014-09-30T08:14:16Z Re: Date from Excel https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724325#M1059134 <HTML><HEAD></HEAD><BODY><P>Thanks mate!</P></BODY></HTML> Tue, 30 Sep 2014 08:25:00 GMT https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724325#M1059134 2014-09-30T08:25:00Z Re: Date from Excel https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724326#M1059135 <HTML><HEAD></HEAD><BODY><P>Welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 30 Sep 2014 08:26:29 GMT https://community.qlik.com/t5/QlikView/Date-from-Excel/m-p/724326#M1059135 ashfaq_haseeb 2014-09-30T08:26:29Z