ODBC data pulls US date to mail merge

I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format (DD/MM/YY) to US format (YYYY-MM-DD) and the only way I can find to resolve this is to switch the columns in smartsheet to a standard text format. Not ideal and how could I change this please? Why is it switching the format of the dates in a date formatted column. The format in the smartsheet is correct (DD/MM/YY) and the regional settings are all to Greenwich as they should be.

Glad of any advice please.

Best Answer