Skip to main content

Code Date Formats

Distributor reference for Code Date Type and Code Date Format on the Product record: Expiration vs Born On dates at receiving, and supplier code formats (Modelo, Heineken, Mikes, Canadian Domestic). Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Steps

  1. Code Date Type and Code Date Format are set on the Product Record.
    ​
    ​

  2. Code Date Type controls whether Expiration or Born On is collected during receiving.
    ​
    ​

  3. Code Date Type should be set to "Expiration Date" or "Born On Date" if the date information entered during receiving will be in the "MMDDYY" format. For any other date format, Code Date Type should be set to "Expiration Code" or "Born On Code"
    ​
    ​

  4. Code Date Format controls how the data information entered will be translated or interpreted by the system and must be populated if Code Date Type is set to "Expiration Code" or "Born on Code" to prevent errors during receiving.
    ​
    ​

  5. Any Code Date Formats using 'D', 'M', or 'Y' specify D for Day, M for Month and Y for Year.
    ​
    ​

  6. All other Code Date Formats are explained in the Fields and Definitions section of this Help Resource Record.

Fields And Definitions

Code Date Format Types for Expiration Date and Born on Code


​Modelo Format 1: ADDY, where D188 represents 4/18/2018. In this format, the first letter represents the month, the next two numbers represent the day, and the last number is the year represented by one number starting at 2011.
​
​Modelo Format 2: AA##, where HI18 represents 4/18/2018. In this format, the first letter represents the year the second letter is the month and the next number is the day.
​
Starting at 2011 or (A) then increasing with a letter all the way to 2022 or (L).
​
The Second letter is on a reverse alphabetical scale going from L-A With L being 1 and A being 12.
​
The last number represents the day going from 1 - 31.
​
​Heineken: #### (1-9)(1-365). The first number represents the year where 1 = 2011 8=2018. The next number represents the number of days in the year. Example: 8010 would equal January 10th, 2018.
​
​Heineken Keg & Heineken CCM: This is a standard DDMMYY format with no spaces or delimiter. Example: 10/12/2017 is represented as 121017.
​
​Mikes: The first 5 characters determine the date and the last 4 represent an ID number. The first letter determines the Month From A-M and skipping the letter “I”. The next 4 digits represent DDYY. Example: M3118A7ME = 12/31/2018 and K2017A7ME = 10/20/2017.
​
​Canadian Domestic: The first character represents the month going from A - M (Excluding the letter “I”). The following 2 characters represent the day, is the days and the last 3 characters represent the year, starting with the letter 'X'. Example: C24X18 = 03/24/18 and M12X16 = 12/12/2016.
​
​Formats without day specified: Some formats only display month and year characters. The first or last day of the specified month is used to determine the code date.
​
For the code date format MMYYYY and MMMYY, the default day is the first day of the month.
​
For the code date format MMYY, the default day is the last day of the month.
​
​

Did this answer your question?