This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
contact-file-preparation-dates [2019/03/11 13:48] benc [Importing Dates into Sentori] |
contact-file-preparation-dates [2019/03/11 14:35] benc [Comma Separated Values (CSV) File] |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| Some examples of this: | Some examples of this: | ||
| - | |**Value**|**Represents**| | + | ^Value^Represented Date^ |
| |25/12/2010|25th December 2010| | |25/12/2010|25th December 2010| | ||
| |01/03/1980|1st March 1980| | |01/03/1980|1st March 1980| | ||
| Line 35: | Line 35: | ||
| + | ===== Comma Separated Values (CSV) File ===== | ||
| + | |||
| + | 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: | ||
| + | |||
| + | <code> | ||
| + | Email,DateValue | ||
| + | "me@example.com",15/01/2018 | ||
| + | "other@example.com",24/06/2018 | ||
| + | </code> | ||
| + | |||
| + | If it's surrounded by any type of quotes, then Sentori probably won't be able to read it as a date. | ||