Formatting a barcode

[Former Member]

hi I have barcodes that are working for various items except a date field and a number field.

I have the following formulas to get the barcode in 2 separate formulas

JBBarCode128B (cstr({Job.Order_Date}))

JBBarCode128B (cstr({Delivery.Shipped_Quantity}))

I need the date to be formatted to YYYYMMDD and currently the quantity comes with a format 1,000 which I need to not have the comma in the thousands

any help would be welcome

thanks

[Former Member]

I also need a number formatting to a certain amount of characters. at the moment it can vary between 7 and 8 characters but it must always be 9 characters and any extra's should be zero's at the beginning on the data.

thanks

kev

[JWiseman]

hi Kevin,

for the data issue you can use syntax like this

totext({your date field},'yyyyMMdd')

please provide an example of exactly what you're looking for as far as the leading 0's. as an example you can always use something like this

right(('0000000000'  + totext({your number field},0)),9)

thanks,

jamie