Hello,
I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond.
Here’s what’s happening:
- In Excel, the date format is set to Custom (e.g., 2/26/2025).
- When imported into Anaplan, the date is interpreted as 26-Feb, where:
- Month = Feb
- The second number after the dash represents the year.
This works fine up to 2028. However, starting in 2029, Anaplan seems to misinterpret the second number as the day instead of the year—especially for February dates and years 2030-2033.
I’ve attached the error message for reference. Has anyone else come across this issue or found a workaround?
Would love to hear your thoughts or suggestions!
