ISoft Wiki - User contributions [en]

ITrack/Shipping Integration

2018-08-30T21:08:35Z

Hheffelbower: /* Shipping Quote Example */ Replaced 2 images with current screenshots (DLS_1.png and DLS_3.png) -- HH

=What is DLS Worldwide=
DLS provides shipping quotes, pickup, and delivery. For information about how to use their web portal as well as signing up for an account, see [https://youtu.be/1wg6Qmvou7Q this tutorial video].

The ITrack/DLS shipping integration provides value to customers by making it faster to get quotes and schedule shipments, but also because all ITrack users' shipping volume is given a group rate. This allows users to get volume discounts they would not normally be able to reach.

For information about rates, as well as signing up for an account, contact Steven Haas: [mailto:shaas@dls-ww.com EMail at shaas@dls-ww.com] or Phone: 612-296-1806

=Configuring DLS Integration=
In order to use the DLS shipping integration in ITrack, several steps must be completed:

1. Contact DLS Worldwide to get an account set up. (Tell them ISoft sent you so that you get the most competitive group negotiated rates)

2. Once you have a DLS portal and account, they should send you a "Customer Account Number" and a "Billing Location Code". If you don't get one, contact ISoft or DLS support and we'll make sure we get you set up.

3. Launch ITrack and go to the following menu, depending on your software version:
ITrack Enterprise: Edit->Integrations->Shipping Integrations...
ITrack Pro: Edit->Options (Shipping Integrations page)

You should see the following screen:

[[File:ShippingConfigEmpty.PNG]]

4. Check "Enable DLS shipping" to enable the DLS shipping subsystem

5. Enter the account # you got from DLS or ISoft into the DLS Account # box. Also enter the billing code you received in the DLS Billing Location Code box. The following file shows an example configuration. Review the "More Settings" section for descriptions of the other fields.

[[File:ShippingConfigFilledOut2.PNG]]

6. Give some users permission to get shipping quotes and/or schedule shipments. This can be done in the same place as other permissions: the menu Edit->Manage Users->User Permissions and Settings... Users without permission at a document's store will not be able to view a shipping quote or schedule the document. For a user to be able to generate quotes, they will need the "DLS: Quote shipments" permission. In order to schedule shipments, they'll need the "DLS: Schedule shipments" permission.

==More Settings==
In the "Shipping Integrations..." menu, there are several other fields you can configure, which are described here.

===Testing Mode===
Check the "Testing mode" checkbox if you'd like to test generating some quotes and scheduling shipments without actually hitting your live DLS shipping portal.
===Quotes Only Mode===
Check the "Disable shipping scheduling" checkbox if you'd like to allow users to view DLS shipping quotes, but not schedule final shipments through the sales screen integration.
===Shipping Markup===
If you'd like to present a markup on all shipping quotes to your salespeople, enter a non-zero % in the Markup field. This does not effect the cost of the shipping presented in your Bill of Lading.
===URL for shipping integration===
You will not usually need to change this value from its default unless you have a custom deployment of the shipping integration. If you do, enter the base URL here. The default is https://shipping.isoftdata.com/dls/index.php

NOTE: you can omit the index.php from the end, but the trailing "/" is required.

=Shipping Quote Example=
The following steps show an example walkthrough of getting a shipping quote from an unsaved sales order using ITrack Enterprise.

1. Open or build a sales order. Either right click and select "Get DLS shipping quote" or click the Advanced Options button and select "Get DLS shipping quote".

[[File:Get Quote.png]]

2. You will be brought to ITrack's Online page with the document information already filled out in the shipment quote form. In the popup, fill out the shipping dimensions and weight, choose whether to insure the shipment, select any accessorial charges required and click the "Get Rates" button.

[[File:DLS_1.png]]

3. You will be shown various shipment quotes for the chosen shipping class, insurance, and extra charges.

[[File:DLS_3.png]]

4. If you only want a quote, you can note the quotes and close the screen to be taken back to the SO screen. If you'd like to schedule one of the shown shipments, simply click on the preferred carrier. The shipment will be scheduled and you will be shown a Bill of Lading that you can print out if you'd like.

[[File:BOL.png]]

File:DLS 3.png

2018-08-30T21:07:07Z

Hheffelbower:

File:DLS 1.png

2018-08-30T21:05:22Z

Hheffelbower: Hheffelbower uploaded a new version of File:DLS 1.png

File:DLS 1.png

2018-08-30T21:04:31Z

Hheffelbower: Hheffelbower uploaded a new version of File:DLS 1.png

File:DLS 1.png

2018-08-30T20:59:16Z

Hheffelbower:

File:31696.png

2018-06-07T17:05:54Z

Hheffelbower:

TSC tag printers

2018-05-16T18:40:52Z

Hheffelbower: /* Setting up the tag printer over the network */

==Setting Up==

# Make sure that the customer has calibrated the Tag Printer before beginning.
## The printer's instruction booklet should tell the customer how to do this (it usually involves a series of button presses).
# Download the latest TSC Tag Printer Driver from [http://www.seagullscientific.com/drivers/tsc-windows-printer-drivers here].
# Run through the installer
## If you can not find the exact model of printer in the list then you can go to 'Have Disk' and browse to 'C:/Seagull' and select the model from the new list.
# Once the printer is created, open up the properties of the printer
## On the General tab, click '''Printing Preferences...'''
## On the '''Page Setup''' tab click the '''Edit...''' button
## Change the '''Label Size''': Width to 4.00 and Height to 5.50
## Click OK
## Select the radio next to '''Portrait 180°'''
## Click the '''Stock''' tab
## Select '''Labels With Marks''' from the '''Type:''' drop down
## Change '''Mark Height:''' to 0.12in
## Click OK
## In the Tag Printer properties dialog, click the '''Advanced''' tab
## Click the '''Printing Defaults...''' button
## Repeat steps 4.2 through 4.9
# In ITrack, go to Edit > Options
# On the Printers tab, select '''Tag''' from the '''Printer Type''' dropdown
# Select the Tag printer that was just setup, from the '''Printer Name''' dropdown
# Open a part on the Part screen and print a tag
# Confirm that everything is fine and dandy

[[Category:Printing]]
[[Category:ITrack/Support]]

==Problems/Solutions==
===Tags print too light to be read===
A problem that has been experienced before is that tags are printing out too light and the information on the tag can't be read.

To fix this issue:
# Open up the tag printer's properties
# Go to the '''General''' tab and hit the '''Printing Preferences''' button
# The Printing Preferences dialog appears, go to the '''Options''' tab
# Change the print speed to 2.00in/sec and the darkness to 15
# Click Ok
# Make the same changes in the '''Printing Defaults''' on the Advanced tab
# There is sometimes an issue where the print speed won't save
# Reopen the '''Printing Preferences (General tab)''' and '''Printing Defaults (Advanced tab)''' dialog
# Check the Options tab to make sure that the Print Speed is 2.00in/sec
# If it has gone back to 4.00in/sec, see the section below titled '''Removing and reinstalling TSC tag printer drivers'''

===Removing and reinstalling TSC tag printer drivers===
# Take note of the printer model and port that the tag printer is using '''Properties > Ports (tab)
# Delete the printer
# In the Printers windows go to '''File > Server Properties > Drivers (tab) >''' find the tag printer in the list, select it and hit '''Remove...'''
# If you get an error about not being able to remove the driver, hit the properties button and take note of the driver path.
# Delete the directory you took note of in the previous step.
# Repeat the steps in the '''Setting Up''' section above.
# Go to the [printers] section in Host.ini and delete the line that begins with 'tag', then go into Edit >> Options and set the 'Tag' option back to the tag printer.
##If this is not done then ITrack will not recognize the new driver automatically and it will print to the Windows Default Printer.
##Another way fix this problem is to select a new printer in Edit >> Options and select a different printer then reselect the tag printer. This will cause ITrack to recognize the new driver and print to it instead of the Windows Default Printer.
# Tell everyone how awesome you are.

== Setting up the tag printer over the network ==
The normal way that we network a tag printer so that multiple computers can connect to it is by hooking the tag printer to another computer through USB and then marking it as shared. After that, on another computer you can use Windows Explorer to navigate to the computer that the tag printer is hooked up to, and then connect it from there.

On certain models of tag printers (like the ME240) there is a built-in modem so that it can be connected straight into the network instead of being installed on a computer first. To accomplish this:
# Connect the tag printer through a CAT5 cable into an ethernet port.
# On the tag printer, use the menu system/LED to find the IP Address of the tag printer. It will probably be something like "Menu >> Network >> Status."
# Once you have the IP Address, install a printer driver of the tag printer on the computer and point the port to the IP Address that you found earlier.
# If all went as planned, you should now be able to print a test page from the tag printer.

===The tag printer is not spitting the tag out to the black line or going past it===
# Add the printer as local (if the tag printer is physically connected to another computer then create a new port that includes the IP address of the computer it is hooked up to)
# Change the Feed Offset to .5 inches (make sure to change it in both the Printing Preferences and Advanced Settings)
# In the Printer '''Properties''' > '''General''' tab > '''Preferences''' > '''Stock''' tab make sure that '''Post-Print Action''' is set to '''Tear Off'''. Then check the same setting in '''Properties''' > '''Advanced''' tab > '''Printing Defaults''' > '''Stock'''

===The tag printer is hooked up to a computer that doesn't have the version of the driver required for the OS version you're trying to add it on===
# Install the tag printer as a local printer, as if it where physically connected to the computer you are trying to network it to
# Add a new port - make it a local port - and give it the port name "\\<name_of_computer_sharing_printer>\<printer_share_name>"

===Windows does not recognize the Tag Printer===
Things to try:
# Power Cycle the printer: Turn off power and unplug the machine for 30 seconds to a minute, then turn it back on and try to print again.
# Plug the tag printer into another USB port and try to print.
# Plug the tag printer into a different computer and test it.

===Windows 8.1 and Printer Installing Issues===
# Windows 8.0 and 8.1 can present some new and frustrating quirks to the process.
# If you install a tag printer in Windows 8/8.1 and the printer does not appear in "Devices and Printers", please see the following Fogbugz case for information on how to work around the problem. [https://isoftdata.fogbugz.com/f/cases/15251/ Fogbugz Case 15251]

===TSC TTP 246M User Manual===
The tag printer user manual can be found at: \\file\ITRACK\Tech Support\Drivers\TTP_246M_344M.pdf

===TSC Diagnostic Tool===
The wonderful folks over at TSC have created a diagnostic tool for their printers. This tool can read the printer status and tell you error the LED codes are describing, what version of printer it is, firmware version, driver version, allow you to do printer configuration and initialization without requiring the user to hold down buttons and interpret codes, set the printer settings described above without having to use the properties dialog, and other magical things. You can find it at \\file\ITRACK\Tech Support\Drivers\DiagTool_133.zip. Just transfer the tool over to the client machine and launch it from anywhere. Note the tool may not work with older versions of firmware, on older tag printers. At the very least it works with a TTP TSC 247. Instructions for using the tool can be found in the user manual (TTP_245p_247_343p_345_user_manual_eng.pdf), which you can find in the same directory on //File/ as the tool.

===TSC Tag Printer Warranties and Refunds===
If a customer is unhappy with their tag printer, they can receive a full refund from Bluestar Inc, the people we buy the printers from, if the purchase was 30 days ago or less.

If the customer believes their tag printer is broken, all tag printers have a 24 month warranty repair policy offered directly by TSC. If the customer stands by their printer being broken, in order to get a warranty repair started, they must call TSC Tech Support and their technicians will work with them to identify what is broken and instruct them where to ship it for a warranty repair. None of that is ISoft's responsibility other than getting the customer contact information they'd need.

===TSC Technical Support===
Phone Number: 1-657-220-7995. Dave is most likely the one you'll be speaking to. 
Old Number: 1-657-258-0808. 
Email: service@tscprinters.com 

===Another Printer's Driver is Overriding the TSC's Settings===
Sometimes another printer's driver is highly aggressive and does not play nice with other drivers on the system. The solution to this is to uninstall the offending driver that is throwing off the TSC driver, however, you will not be able to print to the offending printer on that computer.

List of drivers that override TSC drivers:
* HP Laserjet 200 color M251
* Pretty much any Canon printer

TSC tag printers

2018-05-16T18:40:02Z

Hheffelbower: /* Setting up the tag printer over the network */

==Setting Up==

# Make sure that the customer has calibrated the Tag Printer before beginning.
## The printer's instruction booklet should tell the customer how to do this (it usually involves a series of button presses).
# Download the latest TSC Tag Printer Driver from [http://www.seagullscientific.com/drivers/tsc-windows-printer-drivers here].
# Run through the installer
## If you can not find the exact model of printer in the list then you can go to 'Have Disk' and browse to 'C:/Seagull' and select the model from the new list.
# Once the printer is created, open up the properties of the printer
## On the General tab, click '''Printing Preferences...'''
## On the '''Page Setup''' tab click the '''Edit...''' button
## Change the '''Label Size''': Width to 4.00 and Height to 5.50
## Click OK
## Select the radio next to '''Portrait 180°'''
## Click the '''Stock''' tab
## Select '''Labels With Marks''' from the '''Type:''' drop down
## Change '''Mark Height:''' to 0.12in
## Click OK
## In the Tag Printer properties dialog, click the '''Advanced''' tab
## Click the '''Printing Defaults...''' button
## Repeat steps 4.2 through 4.9
# In ITrack, go to Edit > Options
# On the Printers tab, select '''Tag''' from the '''Printer Type''' dropdown
# Select the Tag printer that was just setup, from the '''Printer Name''' dropdown
# Open a part on the Part screen and print a tag
# Confirm that everything is fine and dandy

[[Category:Printing]]
[[Category:ITrack/Support]]

==Problems/Solutions==
===Tags print too light to be read===
A problem that has been experienced before is that tags are printing out too light and the information on the tag can't be read.

To fix this issue:
# Open up the tag printer's properties
# Go to the '''General''' tab and hit the '''Printing Preferences''' button
# The Printing Preferences dialog appears, go to the '''Options''' tab
# Change the print speed to 2.00in/sec and the darkness to 15
# Click Ok
# Make the same changes in the '''Printing Defaults''' on the Advanced tab
# There is sometimes an issue where the print speed won't save
# Reopen the '''Printing Preferences (General tab)''' and '''Printing Defaults (Advanced tab)''' dialog
# Check the Options tab to make sure that the Print Speed is 2.00in/sec
# If it has gone back to 4.00in/sec, see the section below titled '''Removing and reinstalling TSC tag printer drivers'''

===Removing and reinstalling TSC tag printer drivers===
# Take note of the printer model and port that the tag printer is using '''Properties > Ports (tab)
# Delete the printer
# In the Printers windows go to '''File > Server Properties > Drivers (tab) >''' find the tag printer in the list, select it and hit '''Remove...'''
# If you get an error about not being able to remove the driver, hit the properties button and take note of the driver path.
# Delete the directory you took note of in the previous step.
# Repeat the steps in the '''Setting Up''' section above.
# Go to the [printers] section in Host.ini and delete the line that begins with 'tag', then go into Edit >> Options and set the 'Tag' option back to the tag printer.
##If this is not done then ITrack will not recognize the new driver automatically and it will print to the Windows Default Printer.
##Another way fix this problem is to select a new printer in Edit >> Options and select a different printer then reselect the tag printer. This will cause ITrack to recognize the new driver and print to it instead of the Windows Default Printer.
# Tell everyone how awesome you are.

== Setting up the tag printer over the network ==
The normal way that we network a tag printer so that multiple computers can connect to it is by hooking the tag printer to another computer through USB and then marking it as shared. After that, on another computer you can use Windows Explorer to navigate to the computer that the tag printer is hooked up to, and then connect it from there.

On certain models of tag printers (like the ME240) there is a built-in modem so that it can be connected straight into the network instead of being installed on a computer first. To accomplish this:
# Connect the tag printer through a CAT5 cable into an ethernet port.
# On the tag printer, use the menu system/LED to find the IP Address of the tag printer. It will probably be something like "Menu >> Network >> Status."
# Once you have the IP Address, install a printer driver of the tag printer on the computer and point the port to the IP Address that you found earlier.
# If all went as planned, you should now be able to print a test page from the tag printer.

===The tag printer is not spitting the tag out to the black line or going past it===
# Add the printer as local (if the tag printer is physically connected to another computer then create a new port that includes the IP address of the computer it is hooked up to)
# Change the Feed Offset to .5 inches (make sure to change it in both the Printing Preferences and Advanced Settings)
# In the Printer '''Properties''' > '''General''' tab > '''Preferences''' > '''Stock''' tab make sure that '''Post-Print Action''' is set to '''Tear Off'''. Then check the same setting in '''Properties''' > '''Advanced''' tab > '''Printing Defaults''' > '''Stock'''

===The tag printer is hooked up to a computer that doesn't have the version of the driver required for the OS version you're trying to add it on===
# Install the tag printer as a local printer, as if it where physically connected to the computer you are trying to network it to
# Add a new port - make it a local port - and give it the port name "\\<name_of_computer_sharing_printer>\<printer_share_name>"

===Windows does not recognize the Tag Printer===
Things to try:
# Power Cycle the printer: Turn off power and unplug the machine for 30 seconds to a minute, then turn it back on and try to print again.
# Plug the tag printer into another USB port and try to print.
# Plug the tag printer into a different computer and test it.

===Windows 8.1 and Printer Installing Issues===
# Windows 8.0 and 8.1 can present some new and frustrating quirks to the process.
# If you install a tag printer in Windows 8/8.1 and the printer does not appear in "Devices and Printers", please see the following Fogbugz case for information on how to work around the problem. [https://isoftdata.fogbugz.com/f/cases/15251/ Fogbugz Case 15251]

===TSC TTP 246M User Manual===
The tag printer user manual can be found at: \\file\ITRACK\Tech Support\Drivers\TTP_246M_344M.pdf

===TSC Diagnostic Tool===
The wonderful folks over at TSC have created a diagnostic tool for their printers. This tool can read the printer status and tell you error the LED codes are describing, what version of printer it is, firmware version, driver version, allow you to do printer configuration and initialization without requiring the user to hold down buttons and interpret codes, set the printer settings described above without having to use the properties dialog, and other magical things. You can find it at \\file\ITRACK\Tech Support\Drivers\DiagTool_133.zip. Just transfer the tool over to the client machine and launch it from anywhere. Note the tool may not work with older versions of firmware, on older tag printers. At the very least it works with a TTP TSC 247. Instructions for using the tool can be found in the user manual (TTP_245p_247_343p_345_user_manual_eng.pdf), which you can find in the same directory on //File/ as the tool.

===TSC Tag Printer Warranties and Refunds===
If a customer is unhappy with their tag printer, they can receive a full refund from Bluestar Inc, the people we buy the printers from, if the purchase was 30 days ago or less.

If the customer believes their tag printer is broken, all tag printers have a 24 month warranty repair policy offered directly by TSC. If the customer stands by their printer being broken, in order to get a warranty repair started, they must call TSC Tech Support and their technicians will work with them to identify what is broken and instruct them where to ship it for a warranty repair. None of that is ISoft's responsibility other than getting the customer contact information they'd need.

===TSC Technical Support===
Phone Number: 1-657-220-7995. Dave is most likely the one you'll be speaking to.
Old Number: 1-657-258-0808.
Email: service@tscprinters.com

===Another Printer's Driver is Overriding the TSC's Settings===
Sometimes another printer's driver is highly aggressive and does not play nice with other drivers on the system. The solution to this is to uninstall the offending driver that is throwing off the TSC driver, however, you will not be able to print to the offending printer on that computer.

List of drivers that override TSC drivers:
* HP Laserjet 200 color M251
* Pretty much any Canon printer

File:27765.png

2017-09-28T19:09:53Z

Hheffelbower:

Error saving this Analysis: ER BAD NULL ERROR: Column 'result' cannot be null

2017-06-22T19:21:59Z

Hheffelbower: Created page with "Recently Great American [Appetizers] Snacks was receiving an error on their mobile devices: '''Error saving this Analysis: ER BAD NULL ERROR: Column 'result' cannot be null.''..."

Recently Great American [Appetizers] Snacks was receiving an error on their mobile devices: '''Error saving this Analysis: ER BAD NULL ERROR: Column 'result' cannot be null.''' This was the result of setting the '''Value Type''' for a calculating option to ''''Choice''''. We fixed it by changing the '''Value type''' to ''''Text''''.
[[File:Nampa_Screenshot_20170622-081345.png]]

File:Nampa Screenshot 20170622-081345.png

2017-06-22T19:19:04Z

Hheffelbower:

Presage/Internal:Great American Date Codes

2017-06-08T21:47:55Z

Hheffelbower:

Great American [Appetizers] Snacks has unique date codes for their packaging.

<h2>The Wahoo Date Code</h2>
The Wahoo code is used in both the Nampa and Monroe plants for a number of analyses. For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Wahoo Code would display as ''''NF057J1''''

*The 'N' stands for Nampa. The Monroe plant's initial character is 'M'.
*The 'F' stands for the month of June (controlled by the first of the nested case statement).
*The '05' is the day of the month formatted as a two-digit day using the format '%d'.
*The '7' is the last number of the four-digit year using the RIGHT command to find the first digit on the right of the number, using the format '%y'.
*The 'J' represents the time between midnight and 2 a.m. (controlled by the second of the nested case statement).
*Finally, the '1' indicates the line number within the plant where the product was produced.
{{Code|text=(SELECT 
CASE 
WHEN {?Date Code Format} = "Wahoo" THEN 

CONCAT('N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
 
END)}}
The code above references a choice {?Date Code Format} techs select against the {?Check Timestamp} in an analysis. The date format is compared against a code on the product's packaging. This assures the product packaging is labeled properly. An option name must always be preceded by '{?' and followed by '}' to be recognized as an analysis option. [This link https://www.w3schools.com/SQL/func_date_format.asp] offers a list of date formats for MySQL.

<h2>Best Before/Meilleur Avant YYYY MO DD + Wahoo</h2>
The Nampa plant requested a new date code for a product distributed in Canada. They requested month abbreviations that are not standard to MySQL. Therefore we used a case statement instead of using the date formats. That code looks like the code below. It concatenates 'Best Before/Meilleur Avant ' with the four-digit year, the two-character month (in the first case statment), the two-digit day, and the Wahoo Date Code (above).

For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Date Code would display as ''''Best Before/Meilleur Avant 2018 JN05 NF057J1''''.

{{Code|text=(select case WHEN {?Retail Date Code Format} = "Best Before/Meilleur Avant YYYY MO DD + Wahoo" THEN 
CONCAT('Best Before/Meilleur Avant ', DATE_FORMAT(DATE_ADD({?Check Timestamp}, INTERVAL 12 month), '%Y '), LEFT(date_format(date_add({?Check Timestamp}, interval 12 month), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'JA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'FE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'MR' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'AL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'MA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'JN' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'JL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'AU' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'SE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'OC' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'NO' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'DE' 
END),2), 
date_format(date_add({?Check Timestamp}, interval 12 month),'%d'), ' N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
END)}}

Presage/Internal:Great American Date Codes

2017-06-08T21:45:49Z

Hheffelbower:

Great American [Appetizers] Snacks has unique date codes for their packaging.

<h2>The Wahoo Date Code</h2>
The Wahoo code is used in both the Nampa and Monroe plants for a number of analyses. For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Wahoo Code would display as ''''NF057J1''''

*The 'N' stands for Nampa. The Monroe plant's initial character is 'M'.
*The 'F' stands for the month of June (controlled by the first of the nested case statement).
*The '05' is the day of the month formatted as a two-digit day using the format '%d'.
*The '7' is the last number of the four-digit year using the RIGHT command to find the first digit on the right of the number, using the format '%y'.
*The 'J' represents the time between midnight and 2 a.m. (controlled by the second of the nested case statement).
*Finally, the '1' indicates the line number within the plant where the product was produced.
{{Code|text=(SELECT 
CASE 
WHEN {?Date Code Format} = "Wahoo" THEN 

CONCAT('N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
 
END)}}
The code above references a choice {?Date Code Format} techs select against the {?Check Timestamp} in an analysis. The date format is compared against a code on the product's packaging the tech enters into the Ideal Date Code option. This assures the product packaging is labeled properly. An option name must always be preceeded by '{?' and followed by '}' to be recognized as an analysis option. [This link https://www.w3schools.com/SQL/func_date_format.asp] offers a list of date formats for MySQL.

<h2>Best Before/Meilleur Avant YYYY MO DD + Wahoo</h2>
The Nampa plant requested a new date code for a product distributed in Canada. They requested month abbreviations that are not standard to MySQL. Therefore we used a case statement instead of using the date formats. That code looks like the code below. It concatenates 'Best Before/Meilleur Avant ' with the four-digit year, the two-character month (in the first case statment), the two-digit day, and the Wahoo Date Code (above).

For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Date Code would display as ''''Best Before/Meilleur Avant 2018 JN05 NF057J1''''.

{{Code|text=(select case WHEN {?Retail Date Code Format} = "Best Before/Meilleur Avant YYYY MO DD + Wahoo" THEN 
CONCAT('Best Before/Meilleur Avant ', DATE_FORMAT(DATE_ADD({?Check Timestamp}, INTERVAL 12 month), '%Y '), LEFT(date_format(date_add({?Check Timestamp}, interval 12 month), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'JA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'FE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'MR' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'AL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'MA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'JN' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'JL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'AU' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'SE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'OC' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'NO' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'DE' 
END),2), 
date_format(date_add({?Check Timestamp}, interval 12 month),'%d'), ' N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
END)}}

Presage/Internal:Great American Date Codes

2017-06-08T21:41:32Z

Hheffelbower:

Great American [Appetizers] Snacks has unique date codes for their packaging.

<h2>The Wahoo Date Code</h2>
The Wahoo code is used in both the Nampa and Monroe plants for a number of analysis. For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Wahoo Code would display as ''''NF057J1''''

*The 'N' stands for Nampa. The Monroe plant's initial character is 'M'.
*The 'F' stands for the month of June (controlled by the first of the nested case statement).
*The '05' is the day of the month formatted as a two-digit day using the format '%d'.
*The '7' is the last number of the four-digit year using the RIGHT command to find the first digit on the right of the number, using the format '%y'.
*The 'J' represents the time between midnight and 2 a.m. (controlled by the second of the nested case statement).
*Finally, the '1' indicates the line number within the plant where the product was produced.
{{Code|text=(SELECT 
CASE 
WHEN {?Date Code Format} = "Wahoo" THEN 

CONCAT('N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
 
END)}}
The code above references a choice {?Date Code Format} techs select against the {?Check Timestamp} in an analysis. The date format is compared against a code on the product's packaging the tech enters into the Ideal Date Code option. This assures the product packaging is labeled properly. An option name must always be preceeded by '{?' and followed by '}' to be recognized as an analysis option. [This link https://www.w3schools.com/SQL/func_date_format.asp] offers a list of date formats for MySQL.

<h2>Best Before/Meilleur Avant YYYY MO DD + Wahoo</h2>
The Nampa plant requested a new date code for a product distributed in Canada. They requested month abbreviations that are not standard to MySQL. Therefore we used a case statement instead of using the date formats. That code looks like the code below. It concatenates 'Best Before/Meilleur Avant ' with the four-digit year, the two-character month (in the first case statment), the two-digit day, and the Wahoo Date Code (above).

For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Date Code would display as ''''Best Before/Meilleur Avant 2018 JN05 NF057J1''''.

{{Code|text=(select case WHEN {?Retail Date Code Format} = "Best Before/Meilleur Avant YYYY MO DD + Wahoo" THEN 
CONCAT('Best Before/Meilleur Avant ', DATE_FORMAT(DATE_ADD({?Check Timestamp}, INTERVAL 12 month), '%Y '), LEFT(date_format(date_add({?Check Timestamp}, interval 12 month), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'JA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'FE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'MR' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'AL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'MA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'JN' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'JL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'AU' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'SE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'OC' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'NO' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'DE' 
END),2), 
date_format(date_add({?Check Timestamp}, interval 12 month),'%d'), ' N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
END)}}

Presage/Internal:Great American Date Codes

2017-06-08T21:28:46Z

Hheffelbower:

Great American [Appetizers] Snacks has unique date codes for their packaging.

<h2>The Wahoo Date Code</h2>
The Wahoo code is used in both the Nampa and Monroe plants for a number of analysis. For a date of '''2017-06-05 00:15:01''' (produced on '''Line 1''' in the '''Nampa''' plant), the Wahoo Code would display as ''''NF057J1''''

*The 'N' stands for Nampa. The Monroe plant's initial character is 'M'.
*The 'F' stands for the month of June (controlled by the first of the nested case statement).
*The '05' is the day of the month formatted as a two-digit day using the format '%d'.
*The '7' is the last number of the four-digit year using the RIGHT command to find the first digit on the right of the number, using the format '%y'.
*The 'J' represents the time between midnight and 2 a.m. (controlled by the second of the nested case statement).
*Finally, the '1' indicates the line number within the plant where the product was produced.
{{Code|text=(SELECT 
CASE 
WHEN {?Date Code Format} = "Wahoo" THEN 

CONCAT('N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
 
END)}}
The code above references a choice {?Date Code Format} techs select against the {?Check Timestamp} in an analysis. The date format is compared against a code on the product's packaging the tech enters into the Ideal Date Code option. This assures the product packaging is labeled properly. An option name must always be preceeded by '{?' and followed by '}' to be recognized as an analysis option. [This link https://www.w3schools.com/SQL/func_date_format.asp] offers a list of date formats for MySQL.

<h2>Best Before/Meilleur Avant 2018 JN05 NF057J1</h2>
The Nampa plant requested a new date code for a product distributed in Canada.
{{Code|text=(select case WHEN {?Retail Date Code Format} = "Best Before/Meilleur Avant YYYY MO DD + Wahoo" THEN 
CONCAT('Best Before/Meilleur Avant ', DATE_FORMAT(DATE_ADD({?Check Timestamp}, INTERVAL 12 month), '%Y '), LEFT(date_format(date_add({?Check Timestamp}, interval 12 month), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'JA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'FE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'MR' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'AL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'MA' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'JN' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'JL' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'AU' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'SE' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'OC' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'NO' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'DE' 
END),2), 
date_format(date_add({?Check Timestamp}, interval 12 month),'%d'), ' N', 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 1 THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 2 THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 3 THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 4 THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 5 THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 6 THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 7 THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 8 THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 9 THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 10 THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 11 THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%c') = 12 THEN 'L' 
END, 
date_format({?Check Timestamp},'%d'), 
RIGHT(DATE_FORMAT({?Check Timestamp},'%y'),1), 
CASE 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '05:00:00' AND '07:59:59' THEN 'A' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '08:00:00' AND '09:59:59' THEN 'B' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '10:00:00' AND '11:59:59' THEN 'C' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '12:00:00' AND '13:59:59' THEN 'D' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '14:00:00' AND '15:59:59' THEN 'E' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '16:00:00' AND '17:59:59' THEN 'F' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '18:00:00' AND '19:59:59' THEN 'G' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '20:00:00' AND '21:59:59' THEN 'H' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '22:00:00' AND '23:59:59' THEN 'I' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '00:00:00' AND '01:59:59' THEN 'J' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '02:00:00' AND '03:59:59' THEN 'K' 
WHEN DATE_FORMAT({?Check Timestamp},'%T') BETWEEN '04:00:00' AND '04:59:59' THEN 'L' 
END, 
{?Line}) 
END)}}