TEXTTODATETIME()

Prev Next

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