90% chance you are facing one of these 3 errors:
- Your date column is not correct. Date format needs to be: "YYYY-MM-DD"
- Your delimiter is not correct. Delimiter needs to be comma (,) - not tab, pipe...
- You have a special character ($, @) in your column names.
The fastest way to fix date format
Sometimes, you might get an error message in Pencil if there are problems with the date format in your dataset.
An easy fix is to re-format your date as YYYY-MM-DD.
How to change the date format in a .csv file
Note: Make sure you save and close your file after making your change! If you re-open your .csv file after you've changed the date format, you will notice the date will revert to the default date format (in Australia, d/m/yy) so you'll need to convert it back to yyyy-mm-dd before you close it.
How to change the date format in SQL
For a comprehensive guide on how to convert dates in SQL, please refer to this article.
What type of special characters does Anna accept?
For a complete list of the special characters Anna accepts in column headings and row values, please refer to this article.
If you have any questions, please contact us at firstname.lastname@example.org.