Body: <p>I'm hoping someone can help me with a date problem. I'm importing contacts from my Drupal 7 build and our member's birth dates are not showing up. The short custom code as per the php manual is m/d/Y but that is not an option in the CiviCRM date settings. They offer mm/dd/yyyy. But when I select mm/dd/yyyy, i get repeated values eg. 0505/1313/1955195519551955. Has anyone had this problem and is there a workaround?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-30T16:57:35.203Z
Comments.Text: What do you show here? /civicrm/admin/setting/preferences/date?action=update&id=3&reset=1    as a format?  How are you importing your contacts? Have you tried using Excel(etc.) to reformat the date to a different format Civi accepts?
Comments.UserDisplayName: Zachary
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-30T18:18:10.530Z
Comments.Text: @Zachary I think the poster is referring to the options given on the contact import page, which aren't php format strings just human display. So this sounds like a bug maybe.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-30T19:29:20.807Z
Comments.Text: I just did a test on the public demo at https://dmaster.demo.civicrm.org using Birth Date `05/13/1955` and choosing `mm/dd/yyyy` and it imported correctly. What version of civi are you using?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-31T13:05:20.437Z
Comments.Text: can you past your csv file content 1-2 line?, may be  date field values are incorrect while formatting it.
Comments.UserDisplayName: Sunil Pawar
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-31T18:21:42.020Z
Comments.Text: Thanks so much for your responses. Demerit was closest to what I needed. Turns out the default date option was year-month-date so I needed to match that before I could re-format the display to what I wanted which was 'September 15th, 1952'
Comments.UserDisplayName: Doug Thomson
Tags: <drupal><contacts><import>
Title: PHP Date format not available in CiviCRM
ThreadText: # PHP Date format not available in CiviCRM
  
  (Asked by: username_0 on 2019-10-30)
  
  I'm hoping someone can help me with a date problem. I'm importing contacts from my Drupal 7 build and our member's birth dates are not showing up. The short custom code as per the php manual is m/d/Y but that is not an option in the CiviCRM date settings. They offer mm/dd/yyyy. But when I select mm/dd/yyyy, i get repeated values eg. 0505/1313/1955195519551955. Has anyone had this problem and is there a workaround?
  
  **Tags:** drupal, contacts, import
  
  > **Comments:**
  > **username_1**: What do you show here? /civicrm/admin/setting/preferences/date?action=update&id=3&reset=1    as a format?  How are you importing your contacts? Have you tried using Excel(etc.) to reformat the date to a different format Civi accepts?  
  > **username_2**: @username_1 I think the poster is referring to the options given on the contact import page, which aren't php format strings just human display. So this sounds like a bug maybe.  
  > **username_2**: I just did a test on the public demo at https://dmaster.demo.civicrm.org using Birth Date `05/13/1955` and choosing `mm/dd/yyyy` and it imported correctly. What version of civi are you using?  
  > **username_3**: can you past your csv file content 1-2 line?, may be  date field values are incorrect while formatting it.  
  > **username_0**: Thanks so much for your responses. username_2 was closest to what I needed. Turns out the default date option was year-month-date so I needed to match that before I could re-format the display to what I wanted which was 'September 15th, 1952'  
  
  ---
  
  ## 0 answers
  
  