For Sage Intelligence to know how the database system is expecting the dates, a Date Format property is provided for a connection and is pre-configured. Additionally, different database systems expect dates to be delimited with different characters. This is also pre-configured through the Date Delimiter property.The following list provides an example of date formats that are recognized by some of the more common database systems.
The date picker is enabled for any parameter applied to a date field whose data type is set to a date type in the Connector. Examples of date types are DB Date and DB Timestamp.