Hi Nigel, your issue is unrelated to the original issue which is for lookup. In Workflow, the format of the date should follow the regional settings for the account that run Workflow Service no matter what format of the field set in Forms.  For your issue, please check whether you have used For Each Row activity in Workflow to retrieve the data, if do, then the issue is related to For Each Row activity doesn't follow the Workflow Service's regional settings(This is a known issue for Workflow, will be addressed in next release). You can use For Each Value activity as workaround.

This came up again for another client - is there any other workaround other than switching to US date format or using the For Each Value activity? The latter doesn't really help here as we're retrieving data from a table within the form which as far as I know is the only way to retrieve such data?

We've tried using various date formats, and formatting the date tokens before inserting but it appears that the For Each Row activity discards any date not valid according to the US format.

You still use Retrieve Business Process Variables to get the date from Forms, but after that activity, just need to replace the For Each Row Activity with the For Each Value activity and set this activity to get the value for the date token get from retrieve business process variables(some token like this "%(RetrieveBusinessProcessVariables_Table\Date)"). This activity will respect the reginal settings for the account that run the workflow service.

Following are the steps I tested with:

1. Login the workflow server with a windows user, go to regional and language settings from control panel and change the format to English(United Kingdom).

2. open Services, and change the "Laserfiche Workflow x.x" to log on as the windows user and restart it

3. create a workflow as following to retrieve a date field in a table from forms and send the value for the date via email

The value got from email is "20/12/2016" which is in dd/MM/yyyy format.