topic Re: Date formating issue? in QlikView https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780392#M276526 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use Date(Alt(</P><P>Date#(DateField,'D/M/YYYY'),</P><P>Date#(DateField,'DD/MM/YYYY')</P><P>),'DD/MM/YYYY')</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 12:41:12 GMT PrashantSangle 2015-03-24T12:41:12Z Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780387#M276521 <HTML><HEAD></HEAD><BODY><P><BR />Hi folks,</P><P></P><P>I have date values like below.</P><P>Date field</P><P>2/01/2011</P><P>02/01/2011</P><P>03/01/2011</P><P>04/01/2011</P><P>05/01/2011</P><P>5/1/2011</P><P></P><P>here once i loaded all the data into qlikview.i am getting some date format issues.in date field list box i am getting the</P><P>02/01/2011 and 2/01/2011 (but both are same) </P><P>05/01/2011 and 5/1/2011 (but both are same)</P><P></P><P>can u plz give me idea on it how can i convert this dates into one format only.</P></BODY></HTML> Tue, 24 Mar 2015 12:33:21 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780387#M276521 2015-03-24T12:33:21Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780388#M276522 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use date(Date#(DateField,'D/M/YYYY'),'DD/MM/YYYY')</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 12:37:15 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780388#M276522 PrashantSangle 2015-03-24T12:37:15Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780389#M276523 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Read <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function">http://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function</A></P><P><BR /> </P></BODY></HTML> Tue, 24 Mar 2015 12:39:02 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780389#M276523 Gabriel 2015-03-24T12:39:02Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780390#M276524 <HTML><HEAD></HEAD><BODY><P>Load distinct Right('0' &amp; Date,10) As Date Inline [</P><P>Date</P><P>2/01/2011</P><P>02/1/2011</P><P>02/01/2011</P><P>03/01/2011</P><P>04/01/2011</P><P>05/01/2011</P><P>5/1/2011 ];</P></BODY></HTML> Tue, 24 Mar 2015 12:40:18 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780390#M276524 anbu1984 2015-03-24T12:40:18Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780391#M276525 <HTML><HEAD></HEAD><BODY><P>I tried but it is not giving the proper result</P></BODY></HTML> Tue, 24 Mar 2015 12:40:26 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780391#M276525 2015-03-24T12:40:26Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780392#M276526 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use Date(Alt(</P><P>Date#(DateField,'D/M/YYYY'),</P><P>Date#(DateField,'DD/MM/YYYY')</P><P>),'DD/MM/YYYY')</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 12:41:12 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780392#M276526 PrashantSangle 2015-03-24T12:41:12Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780393#M276527 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>thanks for ur reply</P><P></P><P>but 5/1/2011 how can i get it?</P><P>the above logic vl not for the 5/1/2011 i guess</P></BODY></HTML> Tue, 24 Mar 2015 12:43:47 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780393#M276527 2015-03-24T12:43:47Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780394#M276528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try my reply with alt()</P><P></P><P>This will surely work.</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 12:45:42 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780394#M276528 PrashantSangle 2015-03-24T12:45:42Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780395#M276529 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try this in script .</P><P></P><P>Dates:</P><P>Load * Inline [</P><P>dates</P><P>2/01/2011</P><P>02/01/2011</P><P>03/01/2011</P><P>04/01/2011</P><P>05/01/2011</P><P>5/1/2011</P><P></P><P></P><P>];</P><P></P><P></P><P>temp:</P><P>LOAD</P><P> Date(Date#(dates,'d/mm/yyyy'),'dd-mm-yyyy') as&nbsp; date</P><P> Resident Dates;</P></BODY></HTML> Tue, 24 Mar 2015 12:57:53 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780395#M276529 2015-03-24T12:57:53Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780396#M276530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try in list box also.</P><P></P><P><IMG __jive_id="81689" alt="Untitled.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81689_Untitled.png" style="height: 251px; width: 620px;" /></P></BODY></HTML> Tue, 24 Mar 2015 13:05:08 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780396#M276530 2015-03-24T13:05:08Z Re: Date formating issue? https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780397#M276531 <HTML><HEAD></HEAD><BODY><P>I dont know how, but it works for 5/1/2011 using Right()</P><P></P><P>Load distinct Right('0' &amp; Date,10) As Date,Date(Date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') As Date1 Inline [</P><P>Date</P><P>2/01/2011</P><P>02/1/2011</P><P>02/01/2011</P><P>03/01/2011</P><P>04/01/2011</P><P>05/01/2011</P><P>5/1/2011 ];</P></BODY></HTML> Tue, 24 Mar 2015 13:05:24 GMT https://community.qlik.com/t5/QlikView/Date-formating-issue/m-p/780397#M276531 anbu1984 2015-03-24T13:05:24Z