Format Returned Merge Field Values
1) Click on the Shape Data ribbon button, then Click the Connect Lists option.
2) Double Click the list you want to change, then click the Advanced Settings button, as shown below…
3) The following screen then opens, allowing you to adjust details on a per SharePoint column level.
4) This screen allows you to specifically set the date/time format and other formats on an individual SharePoint column level. Select the Field/SharePoint Column you want, then select the desired format from the drop- down.
5) Finally, Click the Update Selected button which saves your changes.
6) Close out and try your document again to see the new formatting.
