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