Date support for Google Sheets Provider
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.
DATEmust be numbers - if a string (text) is provided, the
#VALUE!error will be returned.
DATEwill 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.
DATEwill 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
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