Months generation from Start Date and Current date

[former_member720952]

Hi Team,

Please see below is my requirement and could you please suggest how can achieve in Web report.

Based on starte date, i need to generated the months column in Webi report

[moshenaveh]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.
Should you wish, you can revise your question by selecting Actions, then Edit.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

[former_member199945]

Hi,

Create a variable as below.

Month = FormatDate([Date];"Mmm")

replace date dimension with report column s dim start date

If you are looking for some other format then refer below document .

https://bobjblog.wordpress.com/2012/03/05/web-intelligence-date-formats

Thanks