Behavior:
When attempting to map a field to your DocuWare Date field in Autoindex, you are unable to see your data source date column available.
Solution:
This is because the data source date column is not of type "Date." If your Autoindex job is using a Database Connection, go to the source database table and make sure that the column field type is "Date."
If your Autoindex job is using a File Connection, please do the following:
- Go into your File Connection in the DocuWare Administration Tool.
- Find your Date column. By default, it is set to Type "Text," which is why it cannot be selected as the data assignment in your Autoindex job.
- You'll need to use the dropdown to change the Type from "Text" to "Date" and then adjust the Date and time format accordingly with the ellipsis.
- Click Apply to save your changes.
- Refresh your Autoindex job, and the data source Date field should be available for data assignment.
KBA is applicable for both Cloud and On-premise Organizations.
