Troubleshooting: Dates are imported as text
If a date in the source data is in a custom format and contains String values (i.e. day of the week (Mon)), it is saved as a String, not a date:
- Thursday, January 14, 2021 - Ok.
- 2021-01-06 - Ok.
- 10-Jan-2021 - Ok.
- 2020-05-12 (Tue) - not Ok.
There are several approaches to follow:
1. Do not set up "2020-05-12 (Tue)" custom format in the source file, use the date format without a day of the week instead (we tested "yyyy/mm/dd" and "yyyy-mm-dd" and both work fine). Set up the needed date format in the destination file:
2. Keep import as is and apply a function on the left to get date values back:
Formula example for this custom data format : =DATE(LEFT(B2,4),MID(B2,6,2),MID(B2,9,2))