Answers.Body: <p>Maybe, the easiest way is, to open the csv in Excel (or LibreCalc) and do some magic with formulas?</p>
  
  <p>Something like </p>
  
  <p><code>=SUBSTITUTE(C9;".";"/")</code></p>
  
  <p>Or even much easier: Open the file in Excel (or LibreCalc) and do some search and replace in the column?</p>
  
  <p>That's the way I would do it, if the file isn't to big for Excel and it isn't a work I had to do every day.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-31T10:52:35.590Z
Answers.Text: I think there is a simpler workaround of just changing the format of the dates to dd/mm/yyyy then saving as csv
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-29T20:45:17.270Z
Answers.LastActivityDate: 2019-12-29T20:45:17.270Z
Answers.UserDisplayName: Tiggr
Answers.Body: <p>I've sure you moved on from this a long time ago but I stumbled across it &amp; figured it was easy enough to fix <a href="https://github.com/civicrm/civicrm-core/pull/30067" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/30067</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-04-26T07:09:11.357Z
Answers.LastActivityDate: 2024-04-26T07:09:11.357Z
Answers.UserDisplayName: eileen
Body: <p>CiviCRM 5.20.2/WP:</p>
  
  <p>My system is using german locale. The contact import does not offer german date format "dd.mm.yyyy", even it is set for birth class in the date settings (dd.mm.yy).</p>
  
  <p>How can I get german date format dd.mm.yyyy supported in the contact importer?</p>
  
  <p>The contact import page only offers these date formats:</p>
  
  <ul>
  <li>yyyy-mm-dd OR yyyymmdd </li>
  <li>mm/dd/yy OR mm-dd-yy</li>
  <li>mm/dd/yyyy OR mm-dd-yyyy</li>
  <li>Month dd, yyyy</li>
  <li>dd/mm/yy</li>
  <li>dd/mm/yyyy</li>
  </ul>
  
Tags: <contacts><import><dates>
Title: Contact Import German Date Format support?
ThreadText: # Contact Import German Date Format support?
  
  (Asked by: username_0 on 2019-12-29)
  
  CiviCRM 5.20.2/WP:
  
  My system is using german locale. The contact import does not offer german date format "dd.mm.yyyy", even it is set for birth class in the date settings (dd.mm.yy).
  
  How can I get german date format dd.mm.yyyy supported in the contact importer?
  
  The contact import page only offers these date formats:
  
  * yyyy-mm-dd OR yyyymmdd
  * mm/dd/yy OR mm-dd-yy
  * mm/dd/yyyy OR mm-dd-yyyy
  * Month dd, yyyy
  * dd/mm/yy
  * dd/mm/yyyy
  
  **Tags:** contacts, import, dates
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-12-29. Score: 2
  
  Maybe, the easiest way is, to open the csv in Excel (or LibreCalc) and do some magic with formulas?
  
  Something like
  
  `=SUBSTITUTE(C9;".";"/")`
  
  Or even much easier: Open the file in Excel (or LibreCalc) and do some search and replace in the column?
  
  That's the way I would do it, if the file isn't to big for Excel and it isn't a work I had to do every day.
  
  > **Comments:**
  > **username_2**: I think there is a simpler workaround of just changing the format of the dates to dd/mm/yyyy then saving as csv  
  
  ---
  
  ### Answer by username_3 on 2024-04-26. Score: 1
  
  I've sure you moved on from this a long time ago but I stumbled across it & figured it was easy enough to fix <https://github.com/civicrm/civicrm-core/pull/30067>
  
  
  ---
  
  