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

Announcements
Join us in Bucharest on Sept 18th 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')