Conversion To Julian Date Help Follow
I am using a trial version of Bartender Professional to replicate a label we created several years ago with another product. About a year ago the computer that the software was loaded on died. We were transitioning to a new MIS at the time, so we tried to recreate the label in Crystal Reports to print directly from the MIS. That was successful when printing to a laser printer. However the barcodes are not scannable when printed from our Zebra GC420d label printers. We really need the ability to print these labels from our Zebra printers.
Our client dictates the format we must use for the label. I have completed it except for one field. Once I get that tackled, I intend to purchase Bartender Professional plus a couple print-only copies.
The field in question is a Date/TIme field from our SQL (2008) database. The client requires the date to be formatted as VDyddd. The prefix "VD" is easy. However, I am stumped as to the process to transform the date to the yddd format, where y is the last digit of the year and ddd is the Julian date.
Any help is much appreciated.
Mainline Printing, Inc.
Michael Toupin (mtoupin
Please sign in to leave a comment.