One year month and year in Dashboard

[former_member221192]

Hi experts,

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

expample:

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_member190855 · Accepted solution]

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.

Runali

[former_member221192 · Accepted solution]

Thank you for your quick response,it is working fine as requirement

[saurabh_sonawane]

if you are using calendar component the the output of the calendar component is in datevalue()

we have to convert that date 1st

formula f6= text(f1,"MM/dd/yyyy")..............(09/15/2014)

f7=text(f1,"MM.yyyy")....................(09.2014)

after the we have to get next upcoming  12 month f9= text(eomonth(f6,11),"mm.yyyy")........(08.2014)

and you the calmonth between operator while filter the query. 

startdate = f7

enddate = f9

map this to prompt

[former_member221192]

Thank you for your response according to your logic I got start date and end date easily