Skip to main content
All CollectionsAdd or upload data to SKU Science
📅 How to use the date format of your file
📅 How to use the date format of your file

This article explains how to customize the date format in the import wizard to avoid tedious conversions

Updated over 2 months ago

Our goal is to provide you with the simplest possible experience so that you can get your forecasts.

One of the challenges that we have to face is to recognize all the date formats that our users can present in their file when importing historical sales (or demand) data. There are multitudes depending on the tool from which your data comes and the location of our users.
In order to simplify your life, SKU Science integrates a technology which allows you to define during the import process, the date format as it exists in your file.
(We have noticed however that some weird formats are not recognized. Let us know if this is the case for your file.)

So in the example below, our date format is "2018/Sep". Thus the month appear in the form of letters and not numbers.
First, we can notice that by default the date isn't interpreted. The wizard shows an interface allowing you to specify what's the starting date in your file.

Note that this will only work if your date are in headers of your file. If your dates are in a single column, or if they are in headers but you prefer to explicitly describe you format, you can use the following alternate settings.

First open the drop-down menu in "Select Date Format".

Select "Custom", the box below appears to define the format.

The table below contains many examples on how to set the format and illustrates the possibilities.

Glancing at the board, we find that:

  • for a year on 4 digits, you must enter "YYYY"

  • for the month on 3 letters here "Jan", just enter "MMM" 

So just enter in the custom field "YYYY / MMM"

We can see that the date format is now correctly interpreted.
You can now try this method with your file, if the format is not listed by default.

Did this answer your question?