1 Reply Latest reply: Oct 9, 2015 6:10 AM by laura howarth RSS

    DATE FORMAT ISSUE

      I am loading an excel file into Qlikview, which has a field with a logged date in. The format of the field is 2015-09-24 06:31:38.


      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.


      Can someone help explain what i am doing wrong. Thanks,

      Laura


      logged date.png

       



        • Re: DATE FORMAT ISSUE
          Gysbert Wassenaar

          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').