Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Convert String into Date and Minus one month

Hi There

I have Date in below format

DateUpdate - September 2015,

I want to subtract one month from it at script level and display in front end.

Note: When Date becomes January 2016 the subtracted date should be automatically December 2015.

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

I did a similar expression in the front end, I don't see why it would not work in the back end. Where exactly are you creating this?

Capture.PNG

View solution in original post

6 Replies
sunny_talwar

May be try this:

Date(AddMonths(Date#(DateUpdate, 'MMMM YYYY'), -1), 'MMMM YYYY')

ashishpalkar
Creator III
Creator III
Author

Thanks Sunny, but this one is not working.

sunny_talwar

I did a similar expression in the front end, I don't see why it would not work in the back end. Where exactly are you creating this?

Capture.PNG

Anonymous
Not applicable

the solution is correct of Sunny T

Regards

ashishpalkar
Creator III
Creator III
Author

Thanks Sunny , it worked.

MarcoWedel

Please mark an answer correct then to close this thread.

Thanks

Regards

Marco