Creating a New Date Format

  1. Select Configuration > Validation Rules > Date Format to open the Date Format screen.
  2. Click New to define a new Date Format.
  3. Specify this information:
    Date Code
    The name of the user-defined date format. Once the date format is defined and configured, it can be then used in the Lottable Validation screen.
    Description
    The Description of the Date Format.
    Example
    Once the date format is completely defined, user can enter an example date in the new format and then click TEST to see if it can convert successfully to regular date format.
    Converts To
    The conversion result of the example date format after it has been converted successfully.

    List view

    Date Element
    The Date element being defined:
    • Day: Portion of the date which defines Day
    • Month: Portion of the Date which defines Month
    • Year: Portion of the date which defines year
    • None: Does not define Day, Month or the Year
    Begin
    The beginning position of the element in the date format.
    End
    The ending position of the element in the date format.
    Field Type
    Is this element character of numeric.
    Date Type
    The type of Date:
    • Gregorian: is the element in regular date format like MMDDYYYY
    • Julian: the number of days since the beginning of the year. Day and month is derived from this
    • Custom: Custom date element. Applicable for Month only.

      Example: JAN for 01, FEB for 02 etc

    Custom
    Clicking Custom is displayed a new window to define custom format for month element.
    How To Process
    Determine how this particular Date Element is processed:
    • Conversion: Date element will be converted
    • Validation: No conversion will be done on the date element. Instead following validations will be performed:
      • Character or Numeric validation as defined in the Field Type
      • Position validation as defined by the Begin and End positions
  4. Click Save to save all entered information.

Example of some Date Formats:

A03108 translates to the date of January 31, 2008. The first character A is for validation purposes only.

Date element Begin End Field type Date type How to process
None 1 1 Character Blanks Validation
Day 1 4 Numeric Julian Conversion
Year 5 6 Numeric Gregorian Conversion

24JAN10 translates to January 24, 2010. Here JAN is a custom month field and designates the first month, January.

Date element Begin End Field type Date type How to process
Day 1 2 Numeric Gregorian Conversion
Month 3 5 Character Custom Conversion
Year 6 7 Numeric Gregorian Conversion

Custom pop-up for month is as follows:

Custom field Month
JAN 1
FEB 2
MAR 3
APR 4
MAY 5
JUN 6
JUL 7
AUG 8
SEP 9
OCT 10
NOV 11
DEC 12