---
title: "TEXTTODATETIME()"
slug: "texttodatetime"
updated: 2025-10-14T16:28:35Z
published: 2025-11-19T15:54:21Z
canonical: "support.tulip.co/texttodatetime"
---

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

# TEXTTODATETIME()

## Description

Parses a datetime from text and format. If a tz identifier is provided, uses that time zone instead of the local time zone.

## Available In

- **Apps**
- **Automations**
- **Analysis**

## Syntax

TEXTTODATETIME(datetime: Text, format: Text, timezone?: Text)

## Example

TEXTTODATETIME('01-01-2019 04:00pm', 'MM-DD-YYYY hh:mma', 'America/New_York') = 01/01/2019 4:00PM

## Additional Information

Formatting: [devhints.io/moment](https://devhints.io/moment)