topic Qlikview Date in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195679#M385751 <HTML><HEAD></HEAD><BODY><P>Hey guys, how is it going?</P><P></P><P>I have a data that comes from a excel spreadsheet, actually, it comes from a report manager where I download a report and then it is read by Qlikview.&nbsp; The point is: To QlikView to read the field data, present in this report, I have to open the excel, sum 0 (+0) the date column present and then reload (I already tried make: Date(Datefield) as Datefield on qlik, but it didn't work).</P><P></P><P>Is there a solution? </P><P></P><P>Sincerely, Bisco</P></BODY></HTML> Wed, 26 Oct 2016 18:30:15 GMT 2016-10-26T18:30:15Z Qlikview Date https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195679#M385751 <HTML><HEAD></HEAD><BODY><P>Hey guys, how is it going?</P><P></P><P>I have a data that comes from a excel spreadsheet, actually, it comes from a report manager where I download a report and then it is read by Qlikview.&nbsp; The point is: To QlikView to read the field data, present in this report, I have to open the excel, sum 0 (+0) the date column present and then reload (I already tried make: Date(Datefield) as Datefield on qlik, but it didn't work).</P><P></P><P>Is there a solution? </P><P></P><P>Sincerely, Bisco</P></BODY></HTML> Wed, 26 Oct 2016 18:30:15 GMT https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195679#M385751 2016-10-26T18:30:15Z Re: Qlikview Date https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195680#M385752 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Can you provide sample data and issue facing with it!</P><P></P><P>-Hirish</P></BODY></HTML> Wed, 26 Oct 2016 18:33:42 GMT https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195680#M385752 HirisH_V7 2016-10-26T18:33:42Z Re: Qlikview Date https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195681#M385753 <HTML><HEAD></HEAD><BODY><P>Have you tried using Date#() function? What format does it come in? May be look into these blogs by HIC</P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Wed, 26 Oct 2016 18:35:32 GMT https://community.qlik.com/t5/QlikView/Qlikview-Date/m-p/1195681#M385753 sunny_talwar 2016-10-26T18:35:32Z