the problem is: i want to combin

[virginie]

the problem is:

i want to combinate year+index as 4 digits

and when i do it i lost the the 4 digits:
ydate = DatePart("yyyy", date)

orderfullID = ydate & "-" & id_order


-----> 2002-1 and not 2002-0001

how can i do that ?
i tried:
orderfullID = ydatee & "-" & STR(id_order)
but it doesnt accept the STR() function

how can i cast the long integer to string with format "0000"???

 

[CajunCenturion]

You might try concatenating by using the Format Function.

orderfullID = ydatee & "-" & Format(id_order, "000#&quot Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Imhoteb]

Hi,

You can control the length of the ID_order.

Select Case Len(id_order)
Case 1
id_order= "000" & id_order
Case 2
id_order= "00" & id_order
Case 3
id_order= "0" & id_order
Case 4
id_order= id_order
End Select
ydate = DatePart("yyyy", date)

orderfullID = ydate & "-" & id_order

Good luck