AnsweredAssumed Answered

Exporting date field as seen

Question asked by willrollo on Mar 18, 2015


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