topic Re: DATE FORMAT ISSUE in QlikView https://community.qlik.com/t5/QlikView/DATE-FORMAT-ISSUE/m-p/945449#M528201 <HTML><HEAD></HEAD><BODY><P>Just formatting the date doesn't change the underlying value, which in your case is a timestamp. So each MM-YY date still has the days and time fractions. Try first getting the start of the month of each timestamp using the MonthStart function and then format it to MM-YY: Date(MonthStart([LOGGED DATE]),'MM-YY').</P></BODY></HTML> Fri, 09 Oct 2015 10:13:37 GMT Gysbert_Wassenaar 2015-10-09T10:13:37Z DATE FORMAT ISSUE https://community.qlik.com/t5/QlikView/DATE-FORMAT-ISSUE/m-p/945448#M528199 <HTML><HEAD></HEAD><BODY><P>I am loading an excel file into Qlikview, which has a field with a logged date in. The format of the field is <SPAN style="font-size: 13.3333px;">2015-09-24 0<SPAN style="font-size: 13.3333px;">6:31:38.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">When i want to change it to MM-YY i use the date(logged_date,'MM-YY') however it returns multiple lines for the same month/year.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can someone help explain what i am doing wrong. Thanks,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Laura<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><IMG alt="logged date.png" class="jive-image image-1" src="/legacyfs/online/101557_logged date.png" style="height: auto;" /></P><P></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Fri, 09 Oct 2015 10:10:26 GMT https://community.qlik.com/t5/QlikView/DATE-FORMAT-ISSUE/m-p/945448#M528199 2015-10-09T10:10:26Z Re: DATE FORMAT ISSUE https://community.qlik.com/t5/QlikView/DATE-FORMAT-ISSUE/m-p/945449#M528201 <HTML><HEAD></HEAD><BODY><P>Just formatting the date doesn't change the underlying value, which in your case is a timestamp. So each MM-YY date still has the days and time fractions. Try first getting the start of the month of each timestamp using the MonthStart function and then format it to MM-YY: Date(MonthStart([LOGGED DATE]),'MM-YY').</P></BODY></HTML> Fri, 09 Oct 2015 10:13:37 GMT https://community.qlik.com/t5/QlikView/DATE-FORMAT-ISSUE/m-p/945449#M528201 Gysbert_Wassenaar 2015-10-09T10:13:37Z