Alternative Input Format property

Previous Next

This property can be used to store additional formats and has a similar function to the convert-alternative-format() action. The alternative formats specified here will also be processed in query mode. Note that the values that you use for this property must be separated by line feeds (Ctrl+Enter).

For example, if you set the property to:

DDMMYY

MMDDYY

DDMM

MONDD

The field will now accept 160197, 011697, 1601, or JAN16, all of which are converted to 16-JAN-1997 when the cursor leaves the field (assuming that the system year is 1997).