Skip to main content
All CollectionsViz FlowicsSettings
Date support for Google Sheets Provider
Date support for Google Sheets Provider
Updated over a week ago

Google Sheets data Provider supports date format inserted in a cell. With this support, you can integrate dates in the graphics you build with Flowics through this provider.

The function DATE allows you to Converts a year, month, and day into a date.

If the data is not formatted it will be taken as a string (text) so you won't be able to show the date as it is in the sheet.

When is this format useful? When we need Flowics to recognize the data as a date. Some examples:

  • You want to use the date to filter, limit, or order the content.

  • You want to use the date for conditional display.

  • You want to convert the Date format to another format in Flowics


=DATE(year, month, day)

  • year - The year component of the date.

  • month - The month component of the date.

  • day - The day component of the date.

Sample Usage


Result 7/20/1969


  • Inputs to DATE must be numbers - if a string (text) is provided, the #VALUE! error will be returned.

  • DATE will silently recalculate numeric dates that fall outside of valid month or day ranges. For example, DATE(1969,13,1), which specifies the illegal month 13, will create a date of 1/1/1970. Similarly, DATE(1969,1,32), which specifies the non-existent 32nd day of January, will create a date of 2/1/1969.

  • DATE will silently truncate decimal values input into the function, e.g. a month of 12.75 will be interpreted as 12.

  • Google Sheets uses the 1900 date system. The first date is 1/1/1900.

  • Between 0 and 1899, Google Sheets adds that value to 1900 to calculate the year. For example, DATE(119,2,1) will create a date of 2/1/2019.

  • For years 1900 to 9999, Google Sheets will use that value as the year. For example, DATE(2019,1,2) will create a date of 1/2/2019.

  • For years less than 0 or greater than 10,000, Google Sheets will return the #NUM! error value.

Reference a cell

This is another format we support. With the function =DATE, you can reference the value of each parameter (year, month, day) from a cell. See the image below

Did this answer your question?