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

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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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: 
souadouert
Specialist
Specialist
‎2018-04-17 05:46 AM

formating month

HELLO

HOW TO EXTRACT  THE PREVIOUS MONTH TO DATE  IN THIS FORMAT 05 04 03 02 ....

thank you

Labels (1)
Labels
708 Views
0 Likes
1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III
‎2018-04-17 05:51 AM

Date(AddMonths(Date#('05','MM'),-1),'MM')

View solution in original post

649 Views
0 Likes
2 Replies
sasiparupudi1
Master III
Master III
‎2018-04-17 05:51 AM

Date(AddMonths(Date#('05','MM'),-1),'MM')

650 Views
0 Likes
YoussefBelloum
Champion
Champion
‎2018-04-17 06:06 AM

What is your date field format ?

649 Views