Monthly release to be issued on May 27th, 2021.
Formerly, dates columns were always imported as string in Toucan’s
database. This is not the case anymore! Any new app will now handle
dates as such. To activate this new behavior on existing apps (created
prior to this release date), add
cast_dates_to_string_at_insertion: false in the
Once activated, this feature flag will change the type of existing date
date. Expect to:
Having columns understood as dates enables operations such as extracting year, day, week number, etc. It’s also easier for charts to order data historically automatically, without any configuration.
We also added new capabilities to import dates natively from Excels, Google Sheets and CSVs files!
We also removed the need of adding a
date block to sorties’ and
tiles’ queries. This block was already added automatically for you when
using the Visual Query Builder, so the change will only affect those of
you using the code mode.