BusinessObjects Board

Formula for Date + 1 month?

general discussion
#1

Hi,

I want to have a formula that takes the current date + 1 month and pull it over a row so I have 1 month increments. In one cell I have =CurrentDate(), and in the next I have =RelativeDate(CurrentDate();+30)

This gets me close to what I want but I would really prefer to manipulate the months instead of days. Is there a way to do this so it is cleaner?

Thanks,

1 Like
#2

What version of BusinessObjects are you using? Is this WebI or Crystal Reports?

In WebI your formula would be…

=RelativeDate(CurrentDate(); 1; MonthPeriod)

You also need to think about the fact that months have different number of days. For example, if the current day is March 31 what do you want from one month out since there is no April 31?

Noel

#3

Hi,

Thanks, forgive me, I am a bit of a n00b with this.

Version 4.2, this is Web Intelligence.

#4

No worries. This is how you learn.

Did that work for you?

#5

Yes it did. Thank you. One more question on this. In my output, I see the date and time. I would really like to format it in just MM/DD/YYYY. Is that possible?

#6

Actually, nevermind, I figured it out. You don’t need to modify the formula, you can just right click, format number and change the formatting of the data output.

Thanks,

1 Like