Presage/Internal:Great American Date Codes - Revision history

Codeman: Added info about Simplot date codes and cleaned up the code snipets a bit

2017-06-16T17:04:33Z

Added info about Simplot date codes and cleaned up the code snipets a bit

Hheffelbower at 21:47, 8 June 2017

2017-06-08T21:47:55Z

← Older revision		Revision as of 16:47, 8 June 2017
Line 48:		Line 48:
	<br>		<br>
	END)}}		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.		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>		<h2>Best Before/Meilleur Avant YYYY MO DD + Wahoo</h2>

Hheffelbower at 21:45, 8 June 2017

2017-06-08T21:45:49Z

← Older revision		Revision as of 16:45, 8 June 2017
Line 2:		Line 2:

	<h2>The Wahoo Date Code</h2>		<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 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 'N' stands for Nampa. The Monroe plant's initial character is 'M'.

Hheffelbower at 21:41, 8 June 2017

2017-06-08T21:41:32Z

← Older revision		Revision as of 16:41, 8 June 2017
Line 50:		Line 50:
	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.		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>		<h2>Best Before/Meilleur Avant YYYY MO DD + Wahoo</h2>
	The Nampa plant requested a new date code for a product distributed in Canada.		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 <br>		{{Code\|text=(select case WHEN {?Retail Date Code Format} = "Best Before/Meilleur Avant YYYY MO DD + Wahoo" THEN <br>
	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),<br>		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),<br>

Hheffelbower at 21:28, 8 June 2017

2017-06-08T21:28:46Z

@@ Line 48: / Line 48: @@
 <br>
 END)}}
-Best Before/Meilleur Avant 2018 JN05 NF057J1
+<h2>Best Before/Meilleur Avant 2018 JN05 NF057J1</h2>

Hheffelbower at 20:56, 8 June 2017

2017-06-08T20:56:44Z

← Older revision		Revision as of 15:56, 8 June 2017
Line 5:		Line 5:

	*The 'N' stands for Nampa. The Monroe plant's initial character is 'M'.		*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 case statement).		*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 '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 '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 case statement).		*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.		*Finally, the '1' indicates the line number within the plant where the product was produced.
	{{Code\|text=(SELECT <br>		{{Code\|text=(SELECT <br>

Hheffelbower at 20:55, 8 June 2017

2017-06-08T20:55:47Z

← Older revision		Revision as of 15:55, 8 June 2017
Line 8:		Line 8:
	*The '05' is the day of the month formatted as a two-digit day using the format '%d'.		*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 '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. ~~using~~ the second case statement.		*The 'J' represents the time between midnight and 2 a.m. (controlled by the second case statement).
	*Finally, the '1' indicates the line number within the plant where the product was produced.		*Finally, the '1' indicates the line number within the plant where the product was produced.
	{{Code\|text=(SELECT <br>		{{Code\|text=(SELECT <br>

Hheffelbower at 20:54, 8 June 2017

2017-06-08T20:54:54Z

← Older revision		Revision as of 15:54, 8 June 2017
Line 2:		Line 2:

	<h2>The Wahoo Date Code</h2>		<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 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''''

	*N stands for Nampa. The Monroe plant's initial character is M.		*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 case statement).		*The 'F' stands for the month of June (controlled by the first case statement).
	*The '05' is the day of the month formatted as a two-digit day using the format '%d'.		*The '05' is the day of the month formatted as a two-digit day using the format '%d'.

Hheffelbower: Created page with "Great American [Appetizers] Snacks has unique date codes for their packaging.

The Wahoo Date Code

The Wahoo code is used in both the Nampa and Monroe plants for a numb..."

2017-06-08T20:53:24Z

Created page with "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 numb..."

New page

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'

*N stands for Nampa. The Monroe plant's initial character is M.
*The 'F' stands for the month of June (controlled by the first 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. using the second 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)}}

Best Before/Meilleur Avant 2018 JN05 NF057J1