Exporting date field as seen
I have seen a few posts related to this issue but none have really solved it.
I have a date field that is set up as in the short format - i.e. 01/01/15
However, when I export a layout, as an excel file, the field reverts to 01/01/2015
I have set the export settings to retain the formatting from FM (13adv) 'Apply current layout's data formatting'
I have set my mac's date and time settings to be the short format.
I cant see any settings in Excel to have default date format.
Surely there must be a way to do this without using a calculation? Thank you