We've recently made some changes to how dates and times are processed and displayed in SquaredUp. Primarily we now ensure dates and times are displayed in a user's local timezone to ensure the data makes sense to them.
For this to apply, the column will need to be specified as a 'Date' column using the
Columns
tab of the tile editor. Previously, this only understand UNIX timestamps and strings in ISO format, but we've extended this to support any specified format, e.g. dd/mm/yyyy or d/M/Y. You can also customise the output format in the same way.
Specifying date input and output formats
- In the tile editor, select the Columnstab
- For the chosen column, set TypetoDate
- Expand the section using the chevron.
- Edit the Output Format and Input Format as required.