Previous Topic: ValidationNext Topic: Internal Format

Understanding Your Data Model › Using Fields › ISO Date

ISO Date

The following table describes default characteristics of the DT# field.

Field Type Attribute

Shipped Default Value


Default Override

Field Details Override

Device Field Override

Implementation name

System data type

External length

Internal length

Decimal places

xxDZ

Alpha

6.0

10

N

-

N

N

N

N

Y

N

N

N

N

N

N

N

N

N

LHS text (Column headings)

RHS text

Field name

Date

N

Y

Y

Y

Y

Y

Keyboard shift

Allow lowercase

Mandatory fill

Valid system name

Mod 10/11 check

DYN

-

-

-

-

N

-

Y

-

Y

N

-

Y

-

Y

N

-

N

-

N

Check condition

Translate values

*NONE

-

N

-

Y

-

Y

-

Field exit option

Edit codes: Input

Output

Report

Y

4

Y

Y

Y

Y

Y

Y

N

Y

Y

Y

Y

Y

Y

-

The DT# type is one of three field types used for fields that represent dates. You can use the *MOVE built-in function to convert among date fields of type DTE, DT#, and D8#.

Note: *MOVE converts the three date types to a field of type NBR differently.

See the chapter "Modifying Action Diagrams" in Building Applications for more information on this conversion and date built-in functions.

For compatibility with standards set by the International Standards Organization (ISO), it is recommended that you use DT# for your date fields. Since the DT# field type meets ISO standards, date fields of this type are interpreted correctly for SQL and Query Manager.