topic Re: Convert String into Date and Minus one month in QlikView

Convert String into Date and Minus one month

ashishpalkar — Tue, 27 Oct 2015 15:41:32 GMT

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.

sunny_talwar — Tue, 27 Oct 2015 15:43:28 GMT

May be try this:

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

ashishpalkar — Tue, 27 Oct 2015 16:05:04 GMT

Thanks Sunny, but this one is not working.

sunny_talwar — Tue, 27 Oct 2015 16:08:39 GMT

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?

Anonymous — Tue, 27 Oct 2015 16:56:07 GMT

the solution is correct of Sunny T

Regards

ashishpalkar — Tue, 27 Oct 2015 18:27:48 GMT

Thanks Sunny , it worked.

MarcoWedel — Tue, 27 Oct 2015 19:25:14 GMT

Please mark an answer correct then to close this thread.

Thanks

Regards

Marco