We updated Date/Time Input and Output Formats in the Klip Editor to make grouping, filtering and sorting easier.
This means updates to:
- Date/Time formats
- Input formats and Unix time format
Please review any components formatted as Date/Time to ensure the expected format is displayed. If data is missing from your Klips, check the Input format to make sure it matches the format of your data or try formatting your data as Text. If you have any questions, please contact firstname.lastname@example.org.
The Date/Time format codes in the Properties panel now use the same format codes as formulas. Prior to this change, two separate date and time libraries were used and caused some inconsistencies.
With this change, the results will be exactly the same if data is formatted in a formula or formatted in the Properties panel making the result of grouping, filtering, and sorting more consistent and predictable.
Input formats and Unix time format
To make automatic format detection more precise, Epoch format has been renamed “Unix time” with additional Input formats: Unix time (as seconds) and Unix time (as milliseconds).
This change will allow more flexibility in handling data formatted as seconds.
In addition, +-0000 or +-00:00 in the Input field are recognized as the GMT timezone.
Group is now applied to the data based on the displayed values in the Klip.
For example, data can contain month and year in the source: Feb 2015, Jan 2016, Jan 2017, Feb 2018. If an Output format is applied to only display the month: Feb, Jan, Jan, Feb, it is now possible to apply a Group to the displayed months: Feb, Jan.
Sort is applied to the data based on the values in the source, detecting the values as date/time data and keeping the chronological ordering.
For example, Feb 2015, Jan 2016, Jan 2017, Feb 2018 formatted as months will now sort in ascending chronological order: Feb, Jan, Jan, Feb or descending chronological order.
Sorting and Grouping
When using both Group and Sort, Sort will be applied to to the Grouped data. This means the Sort will be based on the displayed values.
For example, Feb 2015, Jan 2016, Jan 2017, Feb 2018, displayed as months: Feb, Jan, Jan, Feb, will be Grouped and Sorted as: Jan, Feb.