This is an old revision of the document!
Problems can occur when importing dates due to the different ways applications store them.
Examples of this might be:
This article describes how to ensure your date values are correctly imported into Sentori.
Dates being imported must be in the format DD/MM/YYYY
Some examples of this:
|25/12/2010||25th December 2010|
|01/03/1980||1st March 1980|
While your data may appear to be in the required DD/MM/YYYY format when you open an Excel spreadsheet file, it may not actually be stored in the correct way for Sentori to access it.
To ensure it is, the simplest option is to use Excel's Text to Columns feature.
Different applications create CSV files in different ways, but the key result is for the date values to appear as follows when the CSV file is opened in a simple text editor:
Email,DateValue "firstname.lastname@example.org",15/01/2018 "email@example.com",24/06/2018
If it's surrounded by any type of quotes, then Sentori probably won't be able to read it as a date.