Datatype Conversion Problem
Datatype Conversion Problem
(OP)
My problem is this.
I have a view. The first document in this view contains the last invoice number to be used. Format eg = RUS-0111.
Using StrRight, I extract the number (all to right of "-"). I need to add one to this and then enter the new number into a field.
The problem is that a lot of the numbers, start with a 0, and when I convert to a number in order to add 1, the 0(s) get stripped out. What can I convert it to, which will keep the zeros? I have tried cdl, clng and cint.
I have a view. The first document in this view contains the last invoice number to be used. Format eg = RUS-0111.
Using StrRight, I extract the number (all to right of "-"). I need to add one to this and then enter the new number into a field.
The problem is that a lot of the numbers, start with a 0, and when I convert to a number in order to add 1, the 0(s) get stripped out. What can I convert it to, which will keep the zeros? I have tried cdl, clng and cint.
Talk To Other Members