topic Re: Date to Text in QlikView https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807723#M285171 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 11 Nov 2014 11:23:15 GMT kevbrown 2014-11-11T11:23:15Z Date to Text https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807719#M285167 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I'm looking to change my "start" date to be in a text format so "mmm-yyyy". I only need the min of the start date. I was trying - </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Min</SPAN>(<SPAN style="color: #0000ff;">month</SPAN>(<SPAN style="color: #0000ff;">Date#</SPAN>(<SPAN style="color: #800000;">Start</SPAN>, 'mmm-yyyy'))) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">but it's not working, ideas?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Kev</SPAN></P></BODY></HTML> Tue, 11 Nov 2014 11:12:06 GMT https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807719#M285167 kevbrown 2014-11-11T11:12:06Z Re: Date to Text https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807720#M285168 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try lilke</P><P></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Min</SPAN>(<SPAN style="color: #0000ff;">month</SPAN>(<SPAN style="color: #0000ff;">Date#</SPAN>(<SPAN style="color: #800000;">Start</SPAN>, 'MMM-YYYY'))) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P></BODY></HTML> Tue, 11 Nov 2014 11:18:01 GMT https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807720#M285168 PrashantSangle 2014-11-11T11:18:01Z Re: Date to Text https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807721#M285169 <HTML><HEAD></HEAD><BODY><P>Try like month(Date#('Nov-2014', 'MMM-YYYY')) or Date(Date#('Nov-2014', 'MMM-YYYY'), 'MMM')</P></BODY></HTML> Tue, 11 Nov 2014 11:18:37 GMT https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807721#M285169 senpradip007 2014-11-11T11:18:37Z Re: Date to Text https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807722#M285170 <HTML><HEAD></HEAD><BODY><P>MonthName(min(Date))</P></BODY></HTML> Tue, 11 Nov 2014 11:21:22 GMT https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807722#M285170 ali_hijazi 2014-11-11T11:21:22Z Re: Date to Text https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807723#M285171 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 11 Nov 2014 11:23:15 GMT https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807723#M285171 kevbrown 2014-11-11T11:23:15Z Re: Date to Text https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807724#M285172 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P></P><P>try this one</P><P></P><P>=Date(max([Date_FKDAT]),'MMM-YYYY')</P></BODY></HTML> Tue, 11 Nov 2014 11:32:03 GMT https://community.qlik.com/t5/QlikView/Date-to-Text/m-p/807724#M285172 raviityou 2014-11-11T11:32:03Z