topic Re: Getting months from fields that have dates as 2017/01/01 in QlikView https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67002#M776370 <HTML><HEAD></HEAD><BODY><P>Thanks Anil, it works</P></BODY></HTML> Tue, 08 May 2018 11:24:24 GMT Anonymous 2018-05-08T11:24:24Z Getting months from fields that have dates as 2017/01/01 https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67000#M776368 <HTML><HEAD></HEAD><BODY><P>Hi guys, I have a two fields that have dates ranging from January 2017 up until May 2018 in the following format 2017/01/01. I want to display leave taken in a monthly view. How do I get these dates to reflect as months (May 2018) in terms of creating an expression?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67000#M776368 Anonymous 2020-11-25T16:16:04Z Re: Getting months from fields that have dates as 2017/01/01 https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67001#M776369 <HTML><HEAD></HEAD><BODY><P>May be MonthStart() helps</P><P></P><P><STRONG>MonthStart(Your expression of January 2017)</STRONG></P></BODY></HTML> Tue, 08 May 2018 11:15:50 GMT https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67001#M776369 Anil_Babu_Samineni 2018-05-08T11:15:50Z Re: Getting months from fields that have dates as 2017/01/01 https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67002#M776370 <HTML><HEAD></HEAD><BODY><P>Thanks Anil, it works</P></BODY></HTML> Tue, 08 May 2018 11:24:24 GMT https://community.qlik.com/t5/QlikView/Getting-months-from-fields-that-have-dates-as-2017-01-01/m-p/67002#M776370 Anonymous 2018-05-08T11:24:24Z