topic Re: Date field issue in excel in QlikView https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432215#M489207 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="26784" class="jive-image" alt="date error.PNG" src="/legacyfs/online/26784_date error.PNG" /></P><P>This is when I use the Date#() function</P></BODY></HTML> Thu, 13 Dec 2012 09:55:41 GMT Anonymous 2012-12-13T09:55:41Z Date field issue in excel https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432213#M489205 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have a data in excel and I want to append the date field to my calendar. well in excel some date appears as character string and my challenge is even after using many date functions i have gotten the desired result.</P><P></P><P>Please Help.</P></BODY></HTML> Thu, 13 Dec 2012 05:45:51 GMT https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432213#M489205 Anonymous 2012-12-13T05:45:51Z Re: Date field issue in excel https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432214#M489206 <HTML><HEAD></HEAD><BODY><P>Try using the Date#() function to tell QlikView how to interpret the strings as proper dates.</P><P>Besides that it's hard to help since we don't know what your date format looks like.</P></BODY></HTML> Thu, 13 Dec 2012 09:14:00 GMT https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432214#M489206 Anonymous 2012-12-13T09:14:00Z Re: Date field issue in excel https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432215#M489207 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="26784" class="jive-image" alt="date error.PNG" src="/legacyfs/online/26784_date error.PNG" /></P><P>This is when I use the Date#() function</P></BODY></HTML> Thu, 13 Dec 2012 09:55:41 GMT https://community.qlik.com/t5/QlikView/Date-field-issue-in-excel/m-p/432215#M489207 Anonymous 2012-12-13T09:55:41Z