PLD - Date Format Batch Expiration Date - System Variable 501
I need to print the Batch Expiration Date be shown as DD MMM YY (14 OCT 08) on Sales Orders, etc.
Problem 1: I am using System Variable# 501 but I can't get the Function: Month or Day or Year to work for that field (but was able to get them work on the Date for Row:Delivery Date).
Problem 2: The Day functions displays a single digit - is there an easy solution to show two digits: ie: 01 for January (not 1)?
If I can get these functions to work then I can complete this task by adding a number of fields to compare the contents of the Month field. I found other posts that helped me for this.
Field: 192 - Holds the Month Value (Month Function)
Create two new fields for each month:
Field: 195 - Formula (field_192==10)
Field: 196 - Text Field (OCT) linked to the new field F_195
Note: Fields: 192, 195 would not be visible.
I choose to use System Variable# 501 because the Table: OIBT is not available for Sales Orders.