Posted Thu, 11 Jul 2019 10:18:13 GMT by Ross Hooton Media Manager
I'm just doing some testing on a cloud project I'm working on and have something I can't work out with intelligent indexing for dates.

My regional settings on my admin account are set to UK (dd/mm/yyyy), which is the format I need to store dates in. When I upload a document to a tray and try to index it, it always changes the date to the US format (mm/dd/yyyy) and indexes is as such, even though the date on the document is in the UK format.

An example would be:

the date on my doc is 01/06/2019 (first of June 2019)
when I copy this into the date index field, it changes to 06/01/2019 (sixth of Jan 2019)

We've manually corrected the date field on about 10 documents uploaded so far in our testing and every one has had this issue, so it looks like the intelligent indexing won't learn how to read the date in the format I want.

Is there a way to define the date format of how the system reads and indexes dates?
Posted Thu, 11 Jul 2019 10:19:14 GMT by Matthias Wieland DocuWare Europe GmbH Sr. Director Support EMEA
Dear Ross Hooton! It looks like the Community cannot answer your question. Thats why we have opened a Support Request with the Number SR-71516-C1T0M for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have solved the Support Request. With Best Regards, DocuWare Support Team
Posted Wed, 23 Oct 2019 11:36:14 GMT by Laurent De Dijcker

We are facing the same issue.
How has this been addressed?

Thank you for your quick feedback.
Posted Wed, 23 Oct 2019 12:57:42 GMT by Dave Cannon Solutions Specialist
I had a similar situation in which I was using the date from an eForm. The data in the index was correct, but when I tried to use the date in a workflow email it came out in Europe format (dd/mm/yyyy). What I had to do was create Text based global variable in the workflow. Assign the index value to the global variable, then when I used the global variable in the workflow I used this Format(GV_EuroDate,"MM/dd/yyyy"). This reformatted the value in the global Variable GV_EuroDate from dd/mm/yyy to MM/dd/yyyy. It is so far the only way I found to correct it.

You must be signed in to post in this forum.