format-date-column
Define the format of a date-time column
Last updated
Define the format of a date-time column
Last updated
Define the format of a date-time column and either replace the original column values or add a new column with the reformatted date-time.
data: The datatable containing a column of date values.
source column: The name of the column containing date-time values you want to reformat.
source format: The format of the date-time values in the source column, based on Unicode Technical Standard #35. See https://www.unicode.org/reports/tr35/tr35-dates.html#Date_Field_Symbol_Table. Defaults to ISO 8601.
target column: The name of the column that will contain the formatted date-time values. If unspecified, it defaults to the 'source column' and will replace the original values.
target format: The desired format of the date-time values in the target column, based on Unicode Technical Standard #35. See https://www.unicode.org/reports/tr35/tr35-dates.html#Date_Field_Symbol_Table. Defaults to yy-MM-dd.
TIP: for Microreact projects, ISO 8601 is ideal (yyyy-MM-dd). Using this format Microreact will interpret it correctly and display in browsers using the local browser preferences.
locale: A language locale to be used when formatting the values. See https://date-fns.org/v2.0.1/docs/I18n#supported-languages or https://github.com/date-fns/date-fns/tree/38ff3a18ad84d990b6ebcff1c120ea7ee4400b69/src/locale for a list of supported languages and locale options. If unspecified, locale defaults to 'en-GB'.
data: A datatable containing formatted date values in the target column.
The table below shows some common formats. More information and other format symbols can be found on the Unicode site.
Output from Example data-flo (last column is reformatted)
Standardize date-time formats across different columns with different formats.
Simplify date-time into simple date.
Reformat date to align with a new target audience.
| Example | Format symbols |
|---|---|
2009-06-15T13:45:30.345
yyyy-MM-dd'T'HH:mm:ss.SSS
6/15/09
M/d/yy OR M/dd/yy
06/15/2009
MM/dd/yyyy
15-6-09
dd-M-yy
1:45 PM
hh:mm a
13:45
HH:mm
15 Jun 2009
dd LLL yyyy
