vt7.3RC Update Field Workflow Task for Date field error when mismatching User Date Formats
This issue prevents an Update Fields workflow Task from executing correctly, when updating the value in a Date field, and Users have different Date Formats.
Login as an Admin User which uses the Date format of 'dd-mm-yyyy' - and create a Workflow on a module containing a Date field (On creation, with no conditions) - Add a Task to Update Fields, and select the Date field and enter a Date value. e.g. 17-09-2020
Create a new record (of the module type the Workflow was set to trigger on) and verify that the Workflow correctly sets the Date field to the correct value.
Using another User which has the Date Format set to yyyy-mm-dd and connect via the Webservice/API and create a Record (of the type that will trigger the workflow) and the record that is returned has the Date field set to 0000-00-00 instead of the date that the workflow was trying to set it to.
Change the second User to have the matching Date Format as the first User (dd-mm-yyyy) and create a Record, and the workflow correctly sets the date to the value specified in the Update Fields task.