0 Replies Latest reply on Mar 18, 2015 9:09 AM by willrollo

    Exporting date field as seen


      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