-
Select
to open the
Date Format screen.
-
Click
New to define a new Date
Format.
-
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
-
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
|