Date Formatter Profile
Define the formatting settings to use for a date.
Date Field Formatter Settings

Available formats
List of the available date formats.
Selected formats
List of the selected date formats.
Use the arrows to add or remove a date format.
Double click on an available format to add a date format or double click on a selected format to remove the date format.
Months dictionary
Select the library that contains the months translation tables.
Default value: <None>
Ambiguous date handling
Determine how to deal with multiple dates found matching the selected date formates.
Available options are:
Two digit year rounding
Select the minimum and maximum dates. To be valid a date must be part of it.
Default values: 1900 and 2100
Year interval
2-digit years found after the entered value are considered years to be from the 20th century, dates below it are considered to be from the 21st century.
Default value: 40
Allow empty field
When checked, the date field can be empty.
Output format
Date format to use as result value, this is useful to convert different found date formats into 1 single date format for further processing.
Default value: dd/MM/yyyy
Test Results
Enter a text to test the selected settings.
Process
Test the string with the entered connection settings.
Save
Click the save button to save the settings.
Save as
Click the save as button to save the settings under a new name.
Cancel
Click the cancel button to close the window and return to the list of formats.