Update Column (ToDate)
Function Description
The update column (ToDate) is used to convert a text field into a date field, which is convenient for directly converting the corresponding Data into a date format.
Function entrance
- Toolbox-> Data Processing-> Vector-> Update Column (ToDate).
Operating instructions
- You must use a date field to store the converted information. If not, you can first create a new field in the Attribute Structure key in the Dataset attribute panel.
- Click Toolbox-> Data Processing-> Vector-> Update Column (ToDate) to open the Update Column (ToDate) dialog box.
- Set the Dataset that requires an Update Field in the source data.
- In the Calculated Field input box, select the text field to store the date information. The value of the input text field should be in the specified appropriate format. See the Text Format Support Description for the supported text format.
- Select a date type field in To be Updated Field.
- Take the text format yyyymmdd as an example. After setting, click the Run button, and the result is shown in the following figure:
Caution:
Calculated fields only support the selection of text fields, and if the text in the selected text field is not in the supported format, the correct update results will not be obtained.
Related topics
The property sheet is Copy and Paste.