Text Field Format Specifications
When using the Update Column (ToDate) function, you must specify a text field containing time information. To ensure correct conversion results, the text format in the field needs to follow specific rules.
Date and Time Format Specifiers
The time information contained in the text has specified value ranges. Values exceeding these ranges will not produce correct update results.
|
|
|
|
|
None |
|
|
Range: 01-12 (01=January) |
|
|
None |
|
|
Range: 01-31 |
|
|
None |
|
|
Range: 01-24. Use AM/PM suffixes to distinguish between morning and afternoon times. E.g., 10:05:29PM will be converted to 22:05:29. |
|
|
Range: 00-59 |
|
|
Range: 00-59 |
|
|
Used to concatenate date and time values |
Text Formats
Common text formats and special considerations are described below:
- With delimiters
Supported delimiters include: space, comma (,), slash (/), backslash (\), hyphen (-), colon (:). Different delimiter types can be mixed.
|
|
|
|
|
Year-month-day-hour-minute-second can be omitted from right to left sequentially, but middle components cannot be omitted. E.g., "year-month-hour-minute-second" cannot be recognized. |
|
|
Year can be omitted. The current year will be used by default. |
|
|
E.g., 2023-9-1 will be converted to 2023/09/01. |
|
|
If only year and single-digit month exist, the date will be updated to yyyy/0M/01. |
|
|
With delimiters, reverse order input (day-month-year) is supported. |
- Without delimiters
|
|
|
|
|
Components can be omitted from right to left sequentially, but middle components cannot be omitted. |
|
|
When year is omitted without delimiters, "T" must be used to connect date and time for proper recognition. |
|
|
Single-digit month/day formats are not supported without delimiters. |
|
|
Only year and single-digit month: will update to yyyy/0M/01. |
|
|
Reverse order input (day-month-year) is not supported without delimiters. |
Related Topics