This information is for Google Sheets line chart and sparkline widgets.
The date range functionality for our Google Sheets integration is set up to accept a wide range of date formats.
As long as you're using one of the date formats below, your line charts and sparkline widgets will change based on the date range you've set in our platform.
Acceptable numerical date formats
dd-mm-yyyy
For example: "26-04-2019" for April 26th, 2019
dd/mm/yyyy
For example: "26/04/2019" for April 26th, 2019
mm-yyyy
For example: "04-2019" for April, 2019
mm/yyyy
For example: "04/2019" for April, 2019
Acceptable written date formats
Written month, day, year
For example: "July 1st, 2019" or "July 1, 2019"
Written month, year
For example: "December, 2019"