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

# ETL: StringToISODatetime

> Convert a non-ISO datetime string to ISO 8601 format using a specified format pattern. Use for date standardization in Integrate.io ETL pipelines.

## Description

Converts a non-ISO datetime string whose structure is defined by a format string into an ISO 8601 format.

## Syntax

`StringToISODatetime(string, format)`

## Arguments

*string* - string expression in non-ISO 8601 format.

*format* - string expression. For formatting information, see [http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html](http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html)

## Examples

`StringToISODatetime('10-17-13','MM-dd-yy')` returns 2013-10-17T00:00:00.000Z

## Return value datatype

String

## Impact of null value

If input is null, returns null.