Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to generate dates backwards using addmonths function ?

The scenario is like this,

if i select today's date i.e 15-06-2015 the i need to generate 12 number of dates in backward manner for each month, for example

for date 15-06-2015, it should generate-

15-05-2015

15-04-2015

15-03-2015

15-02-2015

15-01-2015

15-12-2014

15-11-2014

15-10-2014

15-09-2014

.

.

.

15-06-2014




Thanks.

32 Replies
Anonymous
Not applicable
Author

Hi I think preceed me and do this very fine! 🙂

Thank you!

Regards.

Not applicable
Author

Thanks sunindia

sunny_talwar

Not a problem

I am glad we were able to resolve your issue.

Best,

Sunny