Convert String into Date and Minus one month

[ashishpalkar]

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]

May be try this:

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

[ashishpalkar]

Thanks Sunny, but this one is not working.

[sunny_talwar · Accepted solution]

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]

the solution is correct of Sunny T

Regards

[ashishpalkar]

Thanks Sunny , it worked.

[MarcoWedel]

Please mark an answer correct then to close this thread.

Thanks

Regards

Marco