> For the complete documentation index, see [llms.txt](https://community-test.logicnets.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://community-test.logicnets.com/release-9/platform-documentation/process-node-parts/convert-text-to-date.md).
# 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](/release-9/example-gallery/example-projects-for-parts/convert-text-to-date-example-project.md) in your workspace.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.
Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:
```
GET https://community-test.logicnets.com/release-9/platform-documentation/process-node-parts/convert-text-to-date.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.