Add a month to a period format

[nisccrystal]

Hi,

I'm using crystal XI and I'm trying to add a month to a current period (201010) desired result (201011). I need to make sure this works when we go into the next year. Example (201012) plus one month = (201101).

Has anyone tried anything like this before?

Thanks!

 

[lbass]

Is your period field a number or a string?

-LB

 

[nisccrystal]

The period is a number.

 

[lbass]

numbervar x := {table.period};
stringvar y := totext(x,0,"");
if right(y,2) = '12' then
x + 89 else
x + 1

Then format the number to result in no decimals.

-LB