Change Date format for GS1 barcode Follow
First of all im sorry if this has already been posted but i have searched everywhere and cannot seem to find the right solution. I have tried many times and failed so here we go...
I am using Bartender 2016 and have a label where the user is prompted to enter a "PackDate" for a product. This date is displayed on the label in format DD/MM/YYYY without problem and I then have another date diplayed below that for expiry date (EXPDate). This is auto calculated using vbscript from PackDate as value = DateAdd("d",16,PackDate) as its always +16 days from the packing date. (There is possibly a better/easier way to do this and if so im all ears). Both dates are in "clock" DD/MM/YYYY format.
My problem is that i need to display "EXPDate" in TXT format for the GS1 barcode and the date needs to be yymmdd
Everytime I try and convert the date i fail so i am forced to get the user to enter another field in the form which asks them to type the date in the correct format i.e. yymmdd. This does work but sometimes can produce errors if the user is in a rush and enters the date incorrectly. If they could just select one date i.e. PackDate then the rest is done autmatically would save a lot of dramas.
Thanks in advance
Please sign in to leave a comment.