How do I format the date value as yyyy-mm-dd or yy-mm-dd to import? - LabCollector

Search Knowledge Base by Keyword

How do I format the date value as yyyy-mm-dd or yy-mm-dd to import?

You are here:
← All Topics

When you import a date value using an excel/CSV file, the format needs to be yyyy-mm-dd or yy-mm-dd (SQL format).

To modify the date format in an excel file, select the cells corresponding to your date values and open the Format Cells window:

  1. On the Number tab, select Custom from the Category list and type the date format, yyyy-mm-dd or yy-mm-dd, you want in the Type box.
  2. Click OK to save the changes.

Save the excel file in CSV or copy/paste lines and use them in the import system ( KB-Import your data 5.3v).

 Be careful, if you modify the CSV after saving it, the date format needs to be formatted again.

 Date format depends on the country. In France, the date format is aaaa-mm-jj.