Overview

You can specify the format that is used to view date columns where the actual data is not changed, just how it is displayed. This This example explains how to format the display of date columns without changing the actual data. This helps to keep the data looking format consistent even if the format of the provided data is not. This can be enabled with To do this, configure the appropriate columns with the M column type for in the Column types parameter corresponding to the column. Advanced date sorting specifies how to use the M column type to customize how the column data is interpreted as data.

Two date formats are required to support, In this page, two formats that support both interpreting the data , and formatting the display (output) of the data are explained. 

• Input format - This is

...

• the current format specified on the M column type; if nothing is specified, the default format is used. See Advanced date sorting for more details.
• Display format - This is how you want the date to be displayed and sorted. If not specified, the column is displayed

...

• in the same format as the input format. The display format is similar but, necessarily, more complex than the input format. The ~ character is used to

...

• separate the input and display formats to avoid most conflicts with characters used in formats. This is summarized in the succeeding sections.

Examples

...