How to add 2 months to the current date?

[#1]

Hi,

I am trying to figure out how to add 2 months to an expression but only show the current dates in the dimensions. For example, for June, I need to show data in August because of a 60 day grace period. Can someone show me how I can do this without showing August in the dimensions for June.

Please let me know if you need further clarification to answer this question.

Thank you,

Saurav

[#2]

Hi Saurav S

Can you try Addmonths(today(),2), which gives you your expecting result.

hope this helps

thank you

Meher

[#3]

Hi Merwan,

Sorry I forgot to mention. I have already done addmonths in my script but in the dimensions I do not need to see July and August in June. I believe showing the future months will confuse the end users. Do you think there is a solution?

[jonathandienst]

Hi

This is what I would try:

• Create a date island with the date and grace date, something like:    

               DateIsland:

               LOAD

                    TransDate As diDate,

                    AddMonths(TransDate, 2) As diGraceDate

               Resident Data;

• Dimension the chart/table using diDate
• Filter the amounts using GraceDate, an expression something like

               Sum(If(TranDate < diGraceDate, Value))

          or

               Sum(If(Month(TranDate) = Month(diGraceDate), Value))

Hope that helps

Jonathan