topic Re: expression to display mmm-yy in QlikView https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150605#M376078 <HTML><HEAD></HEAD><BODY><P>Date(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ProcessedOn,'MMM-YY')</SPAN></P><P></P><P>or to not only format but change the numerical value to month start:</P><P></P><P><SPAN style="font-size: 13.3333px;">Date(Monthstart(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ProcessedOn),'MMM-YY')</SPAN></P></BODY></HTML> Mon, 08 Aug 2016 18:51:29 GMT MarcoWedel 2016-08-08T18:51:29Z expression to display mmm-yy https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150603#M376076 <HTML><HEAD></HEAD><BODY><P>what is the expression in enterprise for a filter pane to display mmm-yy from a date time stamp?</P><P>This only displays month need it to include year Month(ProcessedOn) </P></BODY></HTML> Mon, 08 Aug 2016 18:46:38 GMT https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150603#M376076 2016-08-08T18:46:38Z Re: expression to display mmm-yy https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150604#M376077 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Date(MonthStart(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>ProcessedOn), 'MMM-YY')</STRONG></SPAN></P></BODY></HTML> Mon, 08 Aug 2016 18:51:05 GMT https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150604#M376077 sunny_talwar 2016-08-08T18:51:05Z Re: expression to display mmm-yy https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150605#M376078 <HTML><HEAD></HEAD><BODY><P>Date(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ProcessedOn,'MMM-YY')</SPAN></P><P></P><P>or to not only format but change the numerical value to month start:</P><P></P><P><SPAN style="font-size: 13.3333px;">Date(Monthstart(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ProcessedOn),'MMM-YY')</SPAN></P></BODY></HTML> Mon, 08 Aug 2016 18:51:29 GMT https://community.qlik.com/t5/QlikView/expression-to-display-mmm-yy/m-p/1150605#M376078 MarcoWedel 2016-08-08T18:51:29Z