Modifying Action Diagrams › Understanding Built-In Functions › Considerations for Date and Time Field Types › Invalid Moves

Previous Topic: Valid Moves

Next Topic: Move All

Invalid Moves

The following moves are not valid:

DTE NBR D8#

D8# NBR DTE

When you move a constant into a date, time, or timestamp field, the required format for the constant depends on the type of the target field. The required formats are shown in the following table.

Required Format for Constant

Target Date/Time Field

CYYMMDD or YYMMDD

YYYYMMDD

YYYY-MM-DD

HHMMSS

HH.MM.SS

YYYY-MM-DD-HH.MM.SS

    DTE

    D8# (DT8)

    DT#

    TME

    TM#

    TS#

For more information on the date and time field types, see Defining a Data Model in the chapter "Understanding Your Data Model," Using Fields topic.