Convert Text to Date
Description
This part allows the system to convert the text entered by an end-user to a date format for use by the application.
Use
You can use this part to convert text to a date, which is useful in cases where a date is required for calculations. The user can select a date from a dropdown menu or enter a customized date format using the standard masks for day, month, and year in a text field and the system can convert the text using that format.
Note: With v8.4, LogicNets expanded the convert-text-to-date part to include typical Excel date formats. The updates allow for dates with and without zero padding as well as for comma, period, and forward-slash separators; for example, 01-01-26 or 1.1.26.
Editor Fields
| Field Name | Description/Use | Type/Options | Optional/Mandatory |
| Data Object | This is the name of the data object once the system converts it to a date. | Data Object | Mandatory |
| Text | This is the name of the data object that contains the text to convert. | Data Object | Mandatory |
| Custom Date Format | Check this box to customize the date format converter below. Use any of the below with separators existing in your custom date input: - YY=MM=DD : hh-mm:ss would translate 20=10=15 08-15:20 to 20201015.081520 (15th October 2020, 815am and 20 seconds) |
Checked | Unchecked | Optional |
| Date Format | This is the format of the date once the text has been converted to date format. MM = month (01) DD = day (24) YY = year (17) YYYY = year (2017) hh = hour (13) mm = minute(05) ss = second (14) If you exclude hhmmss, the system converts the text to the date 20172401.000000. Note that currently the part does not support the use of optional characters; %D to cover both the 5th and 15th day, for example. Days (and months) must be pre-formatted in the source document to be 2 digits, e.g. 05/08 for May 8th. |
MM/DD/YYYY hh:mm:ss | DD/MM/YYYY hh:mm:ss | custom string |
Mandatory |
| Cutoff Year for Century (v7.4+) |
When using custom formats, the system will interpret YY to be prior century before this cutoff and current century after. Example entries: YY=17 converts to 2017 YY=87 converts to 1987 |
Number between 0 and 99 (Default 49) |
Optional |
Example
For an example of the Convert Text to Date part, download and import the following sample project in your workspace.
Reply
Content aside
- 5 yrs agoLast active
- 44Views
-
4
Following