Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression to display mmm-yy

what is the expression in enterprise for a filter pane to display mmm-yy from a date time stamp?

This only displays month need it to include year Month(ProcessedOn)

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Date(MonthStart(ProcessedOn), 'MMM-YY')

View solution in original post

2 Replies
sunny_talwar

May be this:

Date(MonthStart(ProcessedOn), 'MMM-YY')

MarcoWedel

Date(ProcessedOn,'MMM-YY')

or to not only format but change the numerical value to month start:

Date(Monthstart(ProcessedOn),'MMM-YY')