Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Why Did My Modeled Sheet Import Not Import the Data in the Date Columns

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.  

Question

The import file was fully populated but after the import was deemed successful, we found that the system had not imported the data in the date columns. Why is this not working?

Answer

This type of behavior typically occurs when the date column is not formatted to text: mmm-yyyy.  If the format in the import file is not mmm-yyyy, when the values are imported data in the cells will not show up in AP. So, you might check to see if the date format in the import template has been changed to something else, for example date: dd-mm-yyyy.