Crystal formula for barcode display shows extra characters in date format?

[sofseattle]

Hi All,
Crystal 2016 SP8 in use with SAP Business One.
We have 2 date fields that we are converting to a barcode using the "*"+ (@date)+"*" format. The date field formula basically is just taking a date/time field from the database and converting to text in the proper date format(s).
(ToText({Table.DateTime}, "d/m/yyyy")
In previews in Crystal reports just fine and appears to have the proper date formats, however when we try to scan the barcode we are getting extra 0 characters display. This happens for both android and windows devices.

SAMPLE SCAN DISPLAY:
Date1: 06/O19/O2023
Date2: 23/O06/O20

Any ideas on how to fix this?

Thank you in advance for any ideas

 

[BobSuruncle]

In the ToText function, make sure that you use upper case M for the month.
Lower case m is for minutes.

HTH

Bob Suruncle

Bob Suruncle