Text Field Format Description
When using an update column (ToDate), you must specify a text field that contains time information. In order to get the correct conversion result, the format of the text in the field needs to follow certain rules.
Date and time format specifier
The time information contained in the text has a certain range limit, and if it exceeds the specified range, the correct update result will not be obtained.
| None | ||
| Range: 01-12 (01 = 1 month) | ||
| None | ||
| Range: 01-31 | ||
| None | ||
| Range: 01-24. AM and PM may be used after the time to distinguish between the morning and afternoon hours. For example, 10:05: 29PM will be updated to 22:05:29. | ||
| Range: 00-59 | ||
| Range: 00-59 | ||
| Use to concatenate date and time values |
Text format
Common text formats and situations requiring attention are described as follows:
- There is Separator
The supported Separators are (space), (comma), (/), (\), (-), (:); and the Separator in the middle may not be the same type.
| Year, month, day, hour, minute and second can be missing from right to left, but the middle can not be missing, such as year, month, hour, minute and second can not be identified. | ||
| The year can be missing. No year will be updated to the current year by default | ||
| For example, 2023-9-1 is converted to 2023/09/01. | ||
| For years and single digit months only, the date is updated to yyyy/0M/01. | ||
| When Separator is available, the input of year, month and day in reverse order is supported. |
- No Separator
| Year, month, day, hour, minute and second can be missing from right to left, but the middle can not be missing, such as year, month, hour, minute and second can not be identified. | ||
| If there is no Separator and the year is missing, you need to use "T" to concatenate the date and time, otherwise it will not be recognized correctly. | ||
| Single-digit month and single-digit day recognition is not supported without a separator. | ||
| Only years and single digit months, the date is updated to yyyy/0M/01. | ||
| Input of year, month and day in reverse order is not supported without Separator |
Related topics