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

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

How can i add Year to this Month Variable?

Hi Guys,

How can i add Year to this Month Variable?

Month(AddMonths(Today(),-13))

I want it to show Dec 2014

Thanks

1 Solution

Accepted Solutions
maxgro
MVP
MVP

Date(Monthstart(AddMonths(Today(),-13)), 'MMM YYYY')

or without monthstart

View solution in original post

2 Replies
maxgro
MVP
MVP

Date(Monthstart(AddMonths(Today(),-13)), 'MMM YYYY')

or without monthstart

Anonymous
Not applicable
Author

Thanks