Answers.Body: <p>In the CiviCRM engine the usuall date format is YYYYmmdd hhmm. You could try that date format. You could leave out the hhmm part. </p>
  
  <p>Explenation of the format
  - YYYY = year in four digits (2014)
  - mm (months in 2 digits, 01 for january)
  - dd (day of month in 2 digits e.g. 21)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-11T07:03:18.787Z
Answers.LastActivityDate: 2015-05-11T07:03:18.787Z
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Body: <p>Am new at this. I have created custom fields called Date Left and Date Reinstated in the dd/mm/yyyy format. When I try to import the data, days bigger than 12 are shown as errors, and up to 12 come in, but as mm/dd/yyyy. We have already imported into built-in date fields successfully using dd/mm/yyyy. Am using CiviCRM 4.6.2 on Joomla!3.4.1.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-17T08:43:37.723Z
Comments.Text: This might be a bug. I recently fixed a bug CRM-16625 in the importing of the birth_date and deceased_date of Contacts, and it sounds like the symptoms are very similar.
Comments.UserDisplayName: DaveFF
Tags: <civimember><joomla><date-preferences>
Title: Error importing custom date fields when the day of month is above 12
ThreadText: # Error importing custom date fields when the day of month is above 12
  
  (Asked by: username_0 on 2015-05-11)
  
  Am new at this. I have created custom fields called Date Left and Date Reinstated in the dd/mm/yyyy format. When I try to import the data, days bigger than 12 are shown as errors, and up to 12 come in, but as mm/dd/yyyy. We have already imported into built-in date fields successfully using dd/mm/yyyy. Am using CiviCRM 4.6.2 on Joomla!3.4.1.
  
  **Tags:** civimember, joomla, date-preferences
  
  > **Comments:**
  > **username_1**: This might be a bug. I recently fixed a bug CRM-16625 in the importing of the birth_date and deceased_date of Contacts, and it sounds like the symptoms are very similar.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-05-11. Score: 1
  
  In the CiviCRM engine the usuall date format is YYYYmmdd hhmm. You could try that date format. You could leave out the hhmm part.
  
  Explenation of the format
  - YYYY = year in four digits (2014)
  - mm (months in 2 digits, 01 for january)
  - dd (day of month in 2 digits e.g. 21)
  
  
  ---
  
  