Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

One year month and year in Dashboard

Hi experts,

if i pass the input as 09.2014 in dashboard ,i need next one year date and month


input:  09.2014

need like this 09.2014,10.2014,11.2014,12.2014,01.2014,02.2014,03.2014,04.2014,05.2014,06.2014,07.2014,08.2014

suppose input is 01.2014

need like this ,01.2014,02.2014,03.2014,04.2014,05.2014,06.2014,07.2014,08.2014,09.2014,10.2014,11.2014,12.2014

I want dynamically ,below screen shot I have hard coded

Former Member replied

Hi Ganapathy

You can use the formula in the screenshot to get the dates. A2 is the destination of the calendar.

If you need to send the start and end date as parameter A3 and M3 should be sent if MM.YYYY is the format you need to send.

Hope this helps.


2 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question