Behavior:
When using a workflow to write a date to an index field or form field, the date intended to be written is sometimes one day behind.
Solution:
To resolve this behavior, we must re-map the organization's timezone setting to the date value. This can be done using an arithmetic expression that adjusts the date according to the organization's timezone. Please refer to the below steps on how this can be achieved;
1. Identify the organization's timezone setting in the Organization Settings plugin and ensure it is set to the correct value. Once completed, convert the date value to the UTC timezone using the below arithmetic expression in your DocuWare Workflow:
CDate(GV_strDate, NULL, (DWTimeZone.ORG))
2. You can convert your original date to a string with the arithmetic expression CStr(Date) or integrate it in the original expression given using the below arithmetic expression:
CDate(CStr(GV_OrigDate), NULL, (DWTimeZone.ORG))
KBA is applicable for both Cloud and On-premise Organizations.
