A few of the datetime fields in this CSV looks like this:
2022-06-30 14:59:51.7439
I don’t recall ever seeing the additional seconds on the time portion of the datetime.
When I try to import the CSV, it’s pushing the additional seconds into the next cell.
I tried to set the Column data format to Date: MDY, but that’s not working.
How do I fix this?
EDIT
Here is an example of how the CSV fields looks like:
list_id,key,last_sent,last_open,last_click,last_unsubscribe,status,created
52480,[email protected],,,,,active,2018-06-19 16:30:13
52480,[email protected],,,,,active,2021-06-05 21:45:00.8515
52480,[email protected],,,,,active,2018-06-19 16:30:26
52480,[email protected],2022-09-21 02:00:01,2022-06-30 14:59:51.7439,,,active,2020-12-20 22:16:07.6964
52480,[email protected],,,,,unsubscribe,2021-02-02 21:53:42.6817
52480,[email protected],,,,,active,2021-01-05 01:55:19.2891
52480,[email protected],,,,,active,2019-08-28 23:56:34.9039
52480,[email protected],,,,,active,2018-11-06 17:48:08
52480,[email protected],2024-03-28 03:00:30,2023-12-29 15:45:13.7999,,,active,2023-12-24 00:28:43.7133
52480,[email protected],2023-06-06 01:00:20,,,,active,2023-05-14 20:17:38.1719
52480,[email protected],2024-03-14 01:00:04,2024-03-14 3:47:21.1359,,2024-03-14 02:14:22.7706,unsubscribe,2024-03-06 17:54:49.5468
10