How to format dates
Silk support dates in D-M-YYYY and YYYY-M-D formats.
Unfortunately, we don’t support the format used in the US (MDY). We have to pick one over the other, otherwise Silk couldn’t guess whether 5/4/2015 means the 5th of April or the 4th of May in 2015.
For the notation, we support slashes, dashes/hyphens, dots/full stops, and spaces as seperators (e.g. 31/7/2013).
We also support writing out dates in full in the formats D-MMMM-YYYY and D-MMM-YYYY (31 July 2013 and 31 Jul 2013).
Here are all the ways you can enter the date 31 July 2013 into Silk:
|D-M-YYYY formats||YYYY-D-M formats||Full formats|
|31/7/2013||2013/7/31||31 July 2013|
|31-7-2013||2013-7-31||31 Jul 2013|
|31 7 2013||2013 7 31|
Converting dates in Google Sheets or Excel
If you have your dates formatted US-style, or another way that Silk doesn’t recognize correctly, you can convert the dates in Google Sheets or Excel to a format Silk does understand.
In Google Sheets you can format dates by selecting the column that contains dates, and by going to Format > Number > More Formats > More date and time formats…. Select a format that Silk can understand, like YYYY-M-D.
In Excel, select the colum with dates, and go to Format > Cells…. In the Number tab, pick Date as a category. Select a format that Silk can understand, like YYYY-M-D. If you can’t see that format right away, pick ‘United Kingdom’ or ‘Sweden’ in the Location dropdown to get access to the D-M-YYYY and YYYY-M-D formats.
For more information about how date formats differ around the world, see the excellent Date format by country Wikipedia article.
Time series and dates
If you're looking to do time series, it's important to have the proper date formats above, and that you put the dates in your first column (so your datacards will get the date as the title).