Body: <p>I've recently wanted to add the time to my import of external (non-Civi) transactions. Before this, I just imported the date, which is OK, but the data is there, so why not import it?</p>
  
  <p>I keep getting an "Invalid value for field: Receive Date" error when I try to run the import. Here's the value returned in the Import Error file:</p>
  
  <p>Receive Date: 07/28/18 02:34 AM</p>
  
  <p>I know I select the proper date format mm/dd/yy for the first step of my import. I can't figure out what the problem is.</p>
  
  <p>Receive Date is a datetime in SQL in case that might be relevant.
  Civi 5.2.1</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-02T03:40:13.813Z
Comments.Text: sometimes you can get a clue as to what is required by doing an export of some data including that field just to see the format it gives you
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-02T03:40:37.967Z
Comments.Text: have you tried it without the time component?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-02T14:45:29.010Z
Comments.Text: It imports fine without the time component. Good thought to look at an export; the format there is yyyy-mm-dd hh:mm:ss (no am/pm). I tried an import with that format, and received no error (which is an improvement), but the time data was not imported, only the date (time set to 00:00:00 default).
Comments.UserDisplayName: Phil Morice Brubaker
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-08-02T14:59:59.243Z
Comments.Text: you could see if our csvimporter works any better than the core tools - https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport
Comments.UserDisplayName: petednz - fuzion
Tags: <import><dates>
Title: Help on Contribution import - Invalid value for field(s) : Receive Date
ThreadText: # Help on Contribution import - Invalid value for field(s) : Receive Date
  
  (Asked by: username_0 on 2018-08-01)
  
  I've recently wanted to add the time to my import of external (non-Civi) transactions. Before this, I just imported the date, which is OK, but the data is there, so why not import it?
  
  I keep getting an "Invalid value for field: Receive Date" error when I try to run the import. Here's the value returned in the Import Error file:
  
  Receive Date: 07/28/18 02:34 AM
  
  I know I select the proper date format mm/dd/yy for the first step of my import. I can't figure out what the problem is.
  
  Receive Date is a datetime in SQL in case that might be relevant.
  Civi 5.2.1
  
  **Tags:** import, dates
  
  > **Comments:**
  > **username_1**: sometimes you can get a clue as to what is required by doing an export of some data including that field just to see the format it gives you  
  > **username_1**: have you tried it without the time component?  
  > **username_0**: It imports fine without the time component. Good thought to look at an export; the format there is yyyy-mm-dd hh:mm:ss (no am/pm). I tried an import with that format, and received no error (which is an improvement), but the time data was not imported, only the date (time set to 00:00:00 default).  
  > **username_1**: you could see if our csvimporter works any better than the core tools - https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport  
  
  ---
  
  ## 0 answers
  
  