|Analyze | Miscellaneous operations ||
Convert strings into dates, times, or intervals, or format time and dates into strings.
You can perform a bulk change of a date field (date, time, or date+time) into a string field or a string field into a date field.
To perform date and time conversion:
This is the name the 1010data Insights Platform uses to interact with the column. It is also used when writing more advanced value expressions and queries.
The column name must be unique. It may only contain alphanumeric characters or underscores and must begin with an alphabetic character (e.g., percent_total_sales). It may not contain any spaces or other special characters.
This is a required field.
Note: When entered, the Trillion-Row Spreadsheet (TRS) automatically removes special characters, replaces spaces with underscores, and displays a visual indication that a change was made.
When TRS makes these changes, and if nothing has been entered in the Label field, the original text is automatically copied into the Label field.
This is the column heading that displays by default at the top of a column in the user interface.
The column label may contain any combination of uppercase and lowercase letters, numbers, spaces, and special characters. If you want to have a multi-line column label, use the backtick character (`) to separate the lines (e.g., "Percentage of`Total Sales (%)").
Note: On most standard United States keyboards, the backtick (`) character is immediately to the left of 1 key.
While not required, this field is recommended.