Support,
I have 2 fields that I am importing dates into -- Created & Last Changed. With each date attribute, the AwareIM format is M/d/yy h:mm a
AwareIM seems to be importing the times properly, but the dates are inconsistent. Below are 3 sets of records that I imported with the first column showing what the data looks lik in Excel CSV format.
Any ideas what I can do to make this work properly?
Thanks,
Tom
Excel CSV format: AwareM Imported as:
11/1/05 13:45 1/11/05 1:45 PM Created
12/16/05 13:27 4/12/06 1:27 PM Last Changed
2/2/06 14:58 2/2/06 2:58 PM Created
2/3/06 13:58 3/2/06 1:58 PM Last Changed
6/28/06 10:13 4/6/08 10:13 AM Created
6/28/06 10:22 4/6/08 10:22 AM Last Changed
Format of importing of timestamp issue
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
11/1/05 13:45 was imported to: 1/11/05 1:45 PMSo what is inconsistent here?
12/16/05 13:27 was imported to: 4/12/06 1:27 PM
2/2/06 14:58 was imported to: 2/2/06 2:58 PM (this one was OK)
2/3/06 13:58 was imported to: 3/2/06 1:58 PM
6/28/06 10:13 was imported to: 4/6/08 10:13 AM
6/28/06 10:22 was imported to: 4/6/08 10:22 AM
Inconsistencies are noted in bold
I had not read about specifying the format of imported fields. I'll try that.
Thanks,
Tom