DateTime

Can be one of the following values:

The 'Processing Mode' determines which operations are performed on values:

• Format: Values are reformatted, but not filtered.
• Filter: Values are filtered, but not reformatted.
• Both: Values are both filtered and reformatted.
• Validate: Values are only validated.

Choose the mode that best fits your data extraction and validation requirements.

The Value Delimiter property enables a Data Field to store and process multiple values as an array, rather than a single value.

• When set, the field will accept and return multiple values, separated by the specified delimiter.
• Common delimiters include , (comma), ; (semicolon), or custom strings such as | or ~~.
• Choose a delimiter that does not appear in your data values to avoid parsing errors.

Usage

• To allow a field to store multiple entries (such as a list of codes or dates), set the 'Value Delimiter' to the desired character or string.
• When the delimiter is set, the field is treated as an array, and parsing/formatting operations will split and join values using this delimiter.
• If left blank, the field will only accept a single value.

Example:
If the delimiter is ;, a value like A;B;C will be interpreted as three separate entries: A, B, and C.

A combination of the following flags:

The Input Formats property allows you to specify one or more exact date/time formats that will be used to parse input values.

• Enter multiple formats as a comma-separated list (e.g., yyyyMMdd,MM/dd/yyyy,dd-MMM-yyyy).
• Each format should use standard .NET date/time format string syntax.
• Parsing is culture-aware and will use the configured input cultures.
• If none of the specified formats match, standard date/time parsing will be attempted.
• This property is especially useful for handling non-standard, legacy, or mixed-format date/time values.

Example Input Formats

> [!TIP] > Use this property to ensure that all expected date/time input formats are recognized, especially when working with data from multiple sources or legacy systems.

The Input Cultures property specifies which cultures (locales) are considered when parsing numeric input values.

• Add one or more cultures to support parsing numbers in different regional formats (e.g., US English, French, German).
• Each culture determines how numbers are interpreted, including decimal separators, group separators, and digit symbols.
• The order of cultures determines the priority when attempting to parse input.

> [!TIP] > Use this property to ensure that input values are correctly interpreted regardless of their regional formatting.

The Format Specifier property controls how date and time values are displayed and normalized for output.

• Enter a standard or custom .NET date/time format string to specify the desired output format.
• If left blank, the default formatting for the current culture will be used.
• The output is culture-aware and will use the configured output culture for formatting.
• Invalid format strings will result in a validation error.

Formatting Examples

> [!TIP] > For a full list of options, see the .NET documentation for Standard DateTime Format Strings and Custom DateTime Format Strings.

Can be one of the following types:

The Output Culture property determines how numeric values are formatted for display and output.

• Select a culture to control the formatting of numbers, including decimal and group separators, currency symbols, and digit grouping.
• If not set, the document's culture or the system default will be used.

> [!NOTE] > This property affects only the display and output formatting, not the parsing of input values.

The Minimum Value property sets the lowest numeric value that is considered valid for this field.

• Enter a value to restrict input and output to numbers greater than or equal to this minimum.
• Leave blank to use the absolute minimum for the underlying Storage Type.
• Values below this threshold will be rejected during validation.
• Use this property to enforce business rules or data integrity constraints for numeric fields.

The Maximum Value property sets the highest numeric value that is considered valid for this field.

• Enter a value to restrict input and output to numbers less than or equal to this maximum.
• Leave blank to use the absolute maximum for the underlying Storage Type.
• Values above this threshold will be rejected during validation.
• Use this property to prevent out-of-range or invalid data entry.

The Value Range property displays the absolute minimum and maximum values supported by this Storage Type.

• This is a read-only property for informational purposes.
• The displayed range reflects the full range of the underlying numeric type, regardless of any user-specified minimum or maximum.