> ## Documentation Index
> Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DateParse

Parses a text string representing a date in the specified format and returns the equivalent ISO datetime value

**Category:** `date`

**Syntax:**

```
DateParse([text_column], "format")
```

**Returns:** `String`

**Context Filtering:** ✗ No

## Parameters

| Name          | Type             | Required | Description                                                                                                 |
| ------------- | ---------------- | -------- | ----------------------------------------------------------------------------------------------------------- |
| `text_column` | `column or text` | ✓ Yes    | The text string or column of text strings to parse                                                          |
| `format`      | `text`           | ✓ Yes    | The datetime format of the text string using format specifiers (e.g., %Y, %m, %d, %H, %M, %S, %B, %b, etc.) |

**Allowed Column Types for `text_column`:** STRING, TEXT

## Validation

* Minimum parameters: 2
* Maximum parameters: 2

## Examples

```
DateParse("03-Sep-2020:03:05:13", "%d-%b-%Y:%H:%M:%S")
```

Parses the text string and returns the equivalent ISO datetime value
**Result:** `2020-09-03 03:05:13`

```
DateParse([Text Date], "%d/%b/%Y:%H:%M:%S")
```

Parses text strings in the Text Date column using the specified format

```
DateParse([Text Date], "%d/%b/%Y")
```

Parses text strings in the Text Date column using date format only