Skip to main content

Change Column Type From Text To Date In 23degrees

This tutorial guides you through changing a column type from text to date in 23degrees.

Published at May 6, 2026
15 min Reading time
1. Open Data Editor

To change the column type from text to date open the data editor of your visualisation.

Open Data Editor
Open Data Editor
2. Select Column

Click on the column type icon of the column you wish to edit.

Select Column
Select Column
3. Select Column Type

Select "Time".

Select Column Type
Select Column Type
4. Select Language

First select the language you whish your date is going to displayed in. This makes especially sense if how type with written days, weeks or months are displayed.

Select Language
Select Language
5. Select Input Format

Enter the input format of your data. In this case we have a mm/yyyy format. We can look for it but just typing out our input format or scrolling through the options.

Select Input Format
Select Input Format
6. Select Month/Year Example

Select the format.

Select Month/Year Example
Select Month/Year Example
7. Select Output Format

We also have to input an output format. it can be the same as our input format but it can also be a different one

Select Output Format
Select Output Format
8. Select Year Example

In this case we are going to select a different format that only displays the year.

Select Year Example
Select Year Example
9. Confirm Date Format

Click "Ok" to confirm the settings.

Confirm Date Format
Confirm Date Format
10. Select Year 2023

You can now see that our output format is different from our date format in the dataset by checking the chart dropdown.

Select Year 2023
Select Year 2023

You have successfully changed the column type from text to date and configured date formats in 23degrees. Verify the changes by checking the column displays dates correctly. For further customization, explore additional date format options or related data formatting tutorials.