Publisher: change Date format when importing xlsx tables

[Andi-------]

Hi

I imported an xlsx table containing dates. The date format is not as in Excel. I'm working on a Mac, which set up in English but I set the date format for the MacOS (and therefore also Excel) to DD.MM.YYY. After import to publisher, the date format is MM/DD/YYY. Also, when I change the Affinity Publisher language to German, the problem persists. I know, that I can change the date format for fields, but how is this possible for a table?

Edited April 29, 2020 by Andi-------

[Callum]

Hi Andi,

Welcome to the forums :)

If possible could you provide a copy of the xlsx table so I can try some things at my end?

Thanks

C