DATE FORMAT ISSUE

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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