Date code being printed on our shipping labels is printing the wrong week #. Wondering if anyone else has experienced this issue and if they might have a work around for it.
We are using Delmiaworks (IQMS) to print the labels.
Here is the code we put into our crystal report to convert the date to text format.
LEFT (totext({V_LMINVTRY_MANUFACTURED.LABEL_DATE},"yy")+ totext(datepart("WW",DATE({V_LMINVTRY_MANUFACTURED.LABEL_DATE}))),4)
Example: Label was printed on 4/3/25 - date code prints as 2515. should have been 2514.