Answers.Body: <p>Yes, Date fields in export do not respect Date formats set in Localization >> Date Formats. Can you try <a href="https://github.com/pradpnayak/org.civicrm.formatdateexportcolumn" rel="noreferrer">Format Date Column in Export</a> extension? This extension allows to set Export Date format under Localization >> Date Formats and uses this to format the date fields while exporting.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-31T17:25:43.883Z
Answers.Text: That extension is not available on my extension list.  And those instructions appear to be outdated, as this page doesn't exist in my menu Administer >> Customize Data and Screens >> Manage Extensions.  I am using Civi 4.7.29.  I did find this configurations page Settings - Date Preferences, and I tried changing the formats for Searchdata and mailing, but it is still exporting the same way.
Answers.UserDisplayName: fdarn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-31T17:44:42.917Z
Answers.Text: The extension won't be available for auto download since its not released. You will need to manually download the extension into your extension directory and then perform install. The setting in Date Preference will be available upon enabling 'Format Date Column in Export' extension.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-31T18:18:00.190Z
Answers.Text: Please let me know how it goes so that i can go ahead and release the extension for public usage.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-31T08:28:46.557Z
Answers.LastActivityDate: 2017-12-31T08:28:46.557Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I am using Civi 4.7.29 on Wordpress 4.9.1</p>
  
  <p>When exporting the membership list for postal mailing, the expiration date is shown as YYYY-MM-DD.  I would really like it to be MM-DD-YYYY.  </p>
  
  <p>To export I go to Search>Find Memberships, I select my membership type then scroll to the bottom and click search.  On the next page I select All Records, then select Export Members from the drop down menu.  </p>
  
  <p>Is there a better way of doing this to get the date format I need, or are there some settings I can change?  The Localization > Date Formats do not seem to cover the exports.  </p>
  
  <p>Thank you. </p>
  
Tags: <export><date-preferences>
Title: How to change date format in exports
ThreadText: # How to change date format in exports
  
  (Asked by: username_0 on 2017-12-31)
  
  I am using Civi 4.7.29 on Wordpress 4.9.1
  
  When exporting the membership list for postal mailing, the expiration date is shown as YYYY-MM-DD. I would really like it to be MM-DD-YYYY.
  
  To export I go to Search>Find Memberships, I select my membership type then scroll to the bottom and click search. On the next page I select All Records, then select Export Members from the drop down menu.
  
  Is there a better way of doing this to get the date format I need, or are there some settings I can change? The Localization > Date Formats do not seem to cover the exports.
  
  Thank you.
  
  **Tags:** export, date-preferences
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-12-31. Score: 4 | Accepted answer
  
  Yes, Date fields in export do not respect Date formats set in Localization >> Date Formats. Can you try [Format Date Column in Export](https://github.com/pradpnayak/org.civicrm.formatdateexportcolumn) extension? This extension allows to set Export Date format under Localization >> Date Formats and uses this to format the date fields while exporting.
  
  > **Comments:**
  > **username_0**: That extension is not available on my extension list.  And those instructions appear to be outdated, as this page doesn't exist in my menu Administer >> Customize Data and Screens >> Manage Extensions.  I am using Civi 4.7.29.  I did find this configurations page Settings - Date Preferences, and I tried changing the formats for Searchdata and mailing, but it is still exporting the same way.  
  > **username_1**: The extension won't be available for auto download since its not released. You will need to manually download the extension into your extension directory and then perform install. The setting in Date Preference will be available upon enabling 'Format Date Column in Export' extension.  
  > **username_1**: Please let me know how it goes so that i can go ahead and release the extension for public usage.  
  
  ---
  
  