topic Date issue in QlikView https://community.qlik.com/t5/QlikView/Date-issue/m-p/506396#M189311 <HTML><HEAD></HEAD><BODY><P>now, the date is showing like blow as numbers, i want it to be the date format</P><P></P><P>FieldDate</P><P>40909</P><P>40910</P><P>40911</P><P>40912</P><P>40913</P><P>40914</P><P>40915</P><P>40916</P><P></P><P></P><P>i have tried many ways</P><P></P><P>Date(FieldDate)</P><P>Date#(FieldDate, 'YY-MM-DD')</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>interval<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">fLOOR</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[FieldDate]</SPAN><SPAN style="font-size: 8pt;">),'YY-MM-DD') </SPAN></P><P></P><P></P><P></P><P>all are not working, i do not know why</P><P></P></BODY></HTML> Mon, 22 Jul 2013 08:18:23 GMT 2013-07-22T08:18:23Z Date issue https://community.qlik.com/t5/QlikView/Date-issue/m-p/506396#M189311 <HTML><HEAD></HEAD><BODY><P>now, the date is showing like blow as numbers, i want it to be the date format</P><P></P><P>FieldDate</P><P>40909</P><P>40910</P><P>40911</P><P>40912</P><P>40913</P><P>40914</P><P>40915</P><P>40916</P><P></P><P></P><P>i have tried many ways</P><P></P><P>Date(FieldDate)</P><P>Date#(FieldDate, 'YY-MM-DD')</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>interval<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">fLOOR</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[FieldDate]</SPAN><SPAN style="font-size: 8pt;">),'YY-MM-DD') </SPAN></P><P></P><P></P><P></P><P>all are not working, i do not know why</P><P></P></BODY></HTML> Mon, 22 Jul 2013 08:18:23 GMT https://community.qlik.com/t5/QlikView/Date-issue/m-p/506396#M189311 2013-07-22T08:18:23Z Re: Date issue https://community.qlik.com/t5/QlikView/Date-issue/m-p/506397#M189312 <HTML><HEAD></HEAD><BODY><P>Date(FieldDate, 'YY-MM-DD') ?</P></BODY></HTML> Mon, 22 Jul 2013 08:19:59 GMT https://community.qlik.com/t5/QlikView/Date-issue/m-p/506397#M189312 tresB 2013-07-22T08:19:59Z Re: Date issue https://community.qlik.com/t5/QlikView/Date-issue/m-p/506398#M189313 <HTML><HEAD></HEAD><BODY><P>Not working</P></BODY></HTML> Mon, 22 Jul 2013 08:21:19 GMT https://community.qlik.com/t5/QlikView/Date-issue/m-p/506398#M189313 2013-07-22T08:21:19Z Re: Date issue https://community.qlik.com/t5/QlikView/Date-issue/m-p/506399#M189314 <HTML><HEAD></HEAD><BODY><P>its working fine</P><P></P><P>Date( Date,'DD-MM-YY')</P></BODY></HTML> Mon, 22 Jul 2013 08:22:57 GMT https://community.qlik.com/t5/QlikView/Date-issue/m-p/506399#M189314 nizamsha 2013-07-22T08:22:57Z Re: Date issue https://community.qlik.com/t5/QlikView/Date-issue/m-p/506400#M189315 <HTML><HEAD></HEAD><BODY><P>Issue must be somewhere else. Where are you trying this, script? (if yes, how?), at the front end ?(if yes, text box, or any expression?)</P></BODY></HTML> Mon, 22 Jul 2013 08:24:30 GMT https://community.qlik.com/t5/QlikView/Date-issue/m-p/506400#M189315 tresB 2013-07-22T08:24:30Z Re: Date issue https://community.qlik.com/t5/QlikView/Date-issue/m-p/506401#M189316 <HTML><HEAD></HEAD><BODY><P>a:</P><P>LOAD * inline [</P><P>Date</P><P>40909</P><P></P><P>40910</P><P></P><P>40911</P><P></P><P>40912</P><P></P><P>40913</P><P></P><P>40914</P><P></P><P>40915</P><P></P><P>40916</P><P>];</P><P></P><P></P><P>LOAD </P><P> Date( Date,'DD-MM-YY') as Date1 Resident a;</P></BODY></HTML> Mon, 22 Jul 2013 08:26:11 GMT https://community.qlik.com/t5/QlikView/Date-issue/m-p/506401#M189316 nizamsha 2013-07-22T08:26:11Z