Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gz
Contributor III
Contributor III
‎2023-04-21 09:03 AM

Variable for previous month

Hi, i got variable for current month vCurrentMonthYear = Month(Today())& '-' & Year(Today())

how can I change for previous?

Labels (2)
Labels
404 Views
0 Likes
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master
‎2023-04-21 10:24 AM

=Date((Monthname(Today())-1),'MMM-YYYY')

View solution in original post

374 Views
2 Replies
BrunPierre
Partner - Master
Partner - Master
‎2023-04-21 10:24 AM

=Date((Monthname(Today())-1),'MMM-YYYY')

375 Views
gz
Contributor III
Contributor III
‎2023-04-22 01:58 AM
Author

great, thanks 

363 Views
0 Likes