Skip to content

WMS Express

Date format for expiration dates

Viewing 2 posts – 1 through 2 (of 2 total)
  • Author
    Posts
  • #8520
    Andy D.

    Hi,

    I’m trying to scan barcodes that contain an expiration date. I’ve set up a barcode rule, but I’m having problems with the date format. The issue is that the expiration date in my barcode has the format YYMMDD, while my Android device uses the format YYYY-MM-DD.

    Because of this difference, the app doesn’t scan or recognize the date correctly.

    Am I missing any setup steps? How are different date formats typically handled?

    Thanks

    #9992
    Terri V.
    Insight Works

    Hello Andy,

    Business central expects the date to be passed back in a MM/DD/YYYY format, since it’s a NA Based software.

    An example barcode rule to convert that would be
    (.2)(.2)(.2)
    With the Expiry expression being
    $2/$3/20$1

    It is not an android limitation, but a formatting issue of how BC wants to take the date.

    Thank you,

Viewing 2 posts – 1 through 2 (of 2 total)
  • Sign in below to reply.