DateAdd Function Problem

[DugzDMan]

I keep getting a Syntax Error when trying to use the DateAdd function.

Here is the code:
=DateAdd("q", 1, Now)

When I click OK on the message box, it highlights the DateAdd portion of the formula.

Am I missing something here? Is my BO installation hosed a bit?

Thanks!

 

[skrandel]

Where are you gettting this? In Reporter? Designer? I don't see a a DateAdd function at all in Reporter?

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

skrandel@baseconsulting.com

 

[DugzDMan]

I'm getting the error in Reporter. I looked the DateAdd function up again in BO and it ends up that it's a VB function. Since I'm not using it in a macro, that's probably why I'm getting the error.

Here's all I'm trying to do.

I have a cross-tab table with forecasted figures. I would like to figure out the next 6 quarters when the report is refreshed. So, since it is 7-14-03. The next 6 quarters are (4Q03, 1Q04, 2Q04, 3Q04, 4Q04, and 1Q05). I would like those as the column headings on the cross-tab like this:

       4Q03   1Q04   2Q04   3Q04   4Q04   1Q04
AA00   29.1   29.3   29.5   29.7    30    30.3
AH00   14.2   14.8   15.4    16    16.4   16.9
....

Does anyone know of a simple way to calculate the quarter headings above??

Thanks!