Answers.Body: <p>Worked around this by following up on @petednz comment and sticking with the default date format. The failing imports used mm/dd/yyyy (1st snippet below). Selecting the default date format (yyyy-mm-dd) and reformatting the .csv accordingly (2nd snippet) parsed the times correctly.</p>
  <p><a href="https://i.sstatic.net/Ejows.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Ejows.png" alt="Date Format selection" /></a></p>
  <p><a href="https://i.sstatic.net/z1ZEx.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/z1ZEx.png" alt="Reformatted data and mappings" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-14T01:53:04.543Z
Answers.Text: ah good stuff :-)
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-12T20:06:57.787Z
Answers.LastActivityDate: 2022-12-12T20:17:20.287Z
Answers.LastEditDate: 2022-12-12T20:17:20.287Z
Answers.UserDisplayName: wil_SRQ
Body: <p>Importing the .csv quoted below to create Events. The snippet further down shows the field mappings. Everything comes across correctly except the time components of Start Date and End Date, which get set to 12:00 AM of the correct date. Once I get these to work, there are another 200+ to import. Anything I should do differently to capture the correct times?</p>
  <pre>
  Event Type,Start Date,End Date,Title,Default Role,Is Active,Is Public,Share Social
  Performance,11/15/2022 07:00,11/15/2022 14:30,BBTB,Attendee,No,No,No
  Performance,11/17/2022 07:00,11/17/2022 14:30,BBTS,Attendee,No,No,No
  </pre>
  <p>Using extension CSV GUI Import to api v1.10, CiviCRM 5.55.1, Drupal 7.91, PHP 7.4.33, MySQL 5.7.40</p>
  <p><a href="https://i.sstatic.net/y6uoy.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/y6uoy.png" alt="Field mappings" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-11T20:26:15.983Z
Comments.Text: The format i see in the DB is yyyy-mm-dd 00:00:00 - maybe unlikely but perhaps try with the seconds too
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-12T12:09:22.917Z
Comments.Text: Appending the seconds (:00) didn't change the end result. Interesting twist to check, though! In other news, I was able to test the import in the Circle Interactive demo (https://demo.circle-interactive.co.uk/). The result was the same, Start and End times set to midnight.
Comments.UserDisplayName: wil_SRQ
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-12T18:47:30.347Z
Comments.Text: sounds like you need to open an issue. only other quick suggestion would be an sql insert built from your csv
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-12T20:30:54.467Z
Comments.Text: Issue https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/issues/55. Thanks Pete.
Comments.UserDisplayName: wil_SRQ
Tags: <civievent><import>
Title: API CSV import creates events that start and end at midnight
ThreadText: # API CSV import creates events that start and end at midnight
  
  (Asked by: username_0 on 2022-12-11)
  
  Importing the .csv quoted below to create Events. The snippet further down shows the field mappings. Everything comes across correctly except the time components of Start Date and End Date, which get set to 12:00 AM of the correct date. Once I get these to work, there are another 200+ to import. Anything I should do differently to capture the correct times?
  
  ```
  
  Event Type,Start Date,End Date,Title,Default Role,Is Active,Is Public,Share Social
  Performance,11/15/2022 07:00,11/15/2022 14:30,BBTB,Attendee,No,No,No
  Performance,11/17/2022 07:00,11/17/2022 14:30,BBTS,Attendee,No,No,No
  
  ```
  
  Using extension CSV GUI Import to api v1.10, CiviCRM 5.55.1, Drupal 7.91, PHP 7.4.33, MySQL 5.7.40
  
  [![Field mappings](https://i.sstatic.net/y6uoy.png)](https://i.sstatic.net/y6uoy.png)
  
  **Tags:** civievent, import
  
  > **Comments:**
  > **username_1**: The format i see in the DB is yyyy-mm-dd 00:00:00 - maybe unlikely but perhaps try with the seconds too  
  > **username_0**: Appending the seconds (:00) didn't change the end result. Interesting twist to check, though! In other news, I was able to test the import in the Circle Interactive demo (https://demo.circle-interactive.co.uk/). The result was the same, Start and End times set to midnight.  
  > **username_1**: sounds like you need to open an issue. only other quick suggestion would be an sql insert built from your csv  
  > **username_0**: Issue https://github.com/eileenmcnaughton/nz.co.username_1.csvimport/issues/55. Thanks Pete.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-12-12. Score: 2
  
  Worked around this by following up on @username_1 comment and sticking with the default date format. The failing imports used mm/dd/yyyy (1st snippet below). Selecting the default date format (yyyy-mm-dd) and reformatting the .csv accordingly (2nd snippet) parsed the times correctly.
  
  [![Date Format selection](https://i.sstatic.net/Ejows.png)](https://i.sstatic.net/Ejows.png)
  
  [![Reformatted data and mappings](https://i.sstatic.net/z1ZEx.png)](https://i.sstatic.net/z1ZEx.png)
  
  > **Comments:**
  > **username_1**: ah good stuff :-)  
  
  ---
  
  