Notes/Domino 4 and 5 Forum

Hi I have a problem with a sort

There is a hi volume database

What I would like to do is continue passed 9999 to 10000 without having 10000 show up i the wrong space numerically

it should be the next document after 9999 no mixed in with 1000's

Here is the field formula that generates the number

New Formula Returns 10000

@If (@IsNewDoc & @IsDocBeingSaved; @Success; @Return(PDI_IDd));
Num := @DbColumn("Notes":"NoCache"; ""; "GetNumber"; 1);
Num1 := @If(@IsError(Num) | Num=""; 0; @TextToNumber(@Subset(Num; 1)));
NewNum := @Text(Num1+1);
@Right("00000" + NewNum; 5)

Old Formula returns upto 9999

@If (@IsNewDoc & @IsDocBeingSaved; @Success; @Return(PDI_IDd));
Num := @DbColumn("Notes":"NoCache"; ""; "GetNumber"; 1);
Num1 := @If(@IsError(Num) | Num=""; 0; @TextToNumber(@Subset(Num; 1)));
NewNum := @Text(Num1+1);
@Right("00000" + NewNum; 5)

View Formula is the fieldname PDI_IDd