topic Re: Date Format Issue in While exporting to Excel in QlikView https://community.qlik.com/t5/QlikView/Date-Format-Issue-in-While-exporting-to-Excel/m-p/1295664#M404453 <HTML><HEAD></HEAD><BODY><P>Can you explain how you separated the dates into day, month, year and time? Did you create separate fields for each of them in a calendar table? What do you mean by adding the fields as date? Did you do a MakeDate(Year,Month,Day)? </P></BODY></HTML> Fri, 21 Apr 2017 08:14:43 GMT petter 2017-04-21T08:14:43Z Date Format Issue in While exporting to Excel https://community.qlik.com/t5/QlikView/Date-Format-Issue-in-While-exporting-to-Excel/m-p/1295663#M404452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>During optimizing our application, I have separated dates into day, month year and time, In the application I have added the fields as date. While exporting the date into excel its showing as text and not in date. </P><P></P><P>Please help.</P><P></P><P>Regards,</P><P>Muthu</P></BODY></HTML> Fri, 21 Apr 2017 06:44:37 GMT https://community.qlik.com/t5/QlikView/Date-Format-Issue-in-While-exporting-to-Excel/m-p/1295663#M404452 Muthu 2017-04-21T06:44:37Z Re: Date Format Issue in While exporting to Excel https://community.qlik.com/t5/QlikView/Date-Format-Issue-in-While-exporting-to-Excel/m-p/1295664#M404453 <HTML><HEAD></HEAD><BODY><P>Can you explain how you separated the dates into day, month, year and time? Did you create separate fields for each of them in a calendar table? What do you mean by adding the fields as date? Did you do a MakeDate(Year,Month,Day)? </P></BODY></HTML> Fri, 21 Apr 2017 08:14:43 GMT https://community.qlik.com/t5/QlikView/Date-Format-Issue-in-While-exporting-to-Excel/m-p/1295664#M404453 petter 2017-04-21T08:14:43Z