This activity parses a string into a
Date Time. You simply tell it what format of datetime to expect and it’ll parse and convert the input string into a
Date Time variable.
The input expected by this activity will vary slightly depending on whether or not you’re using a default date format or using a custom one. In either case, you need to provide the
Input String to parse into a
If you want to use one of the default date formats, you just select the output format you want. If you want to use a custom format, you check the
Use Custom Datetime Format box and provide your own format (as described below).
- When using the variable browser to use this activity’s output, be careful which variable you select. Every activity has a
End timewhich represent when the activity itself started and stopped running. The output from the activity is actually in the
Supported Input Date Formats
The following datetime formats can be used as input into this activity:
2018-01-02T15:04:05-0700 Tue Jan 2 15:04:05 2018 Tue Jan 2 15:04:05 MST 2018 Tue Jan 02 15:04:05 -0700 2018 02 Jan 18 15:04 MST 02 Jan 18 15:04 -0700 Tuesday, 02-Jan-18 15:04:05 MST Tue, 02 Jan 2018 15:04:05 MST Tue, 02 Jan 2018 15:04:05 -0700 2018-01-02T15:04:05Z 2018-01-02T15:04:05-07:00 2018-01-02T15:04:05.999999999Z 2018-01-02T15:04:05.999999999-07:00 20180102-150405 02012018-150405 (Europe time format) 2018-01-02 02-01-2018
Custom Datetime Formats
If you want to define your own datetime input format, you can use the placeholders defined below to create your own format:
LongMonth = 'January' Month = 'Jan' NumMonth = '1' ZeroMonth = '01' LongWeekDay = 'Monday' WeekDay = 'Mon' Day = '2' UnderDay = '_2' ZeroDay = '02' Hour = '15' Hour12 = '3' ZeroHour12 = '03' Minute = '4' ZeroMinute = '04' Second = '5' ZeroSecond = '05' LongYear = '2018' Year = '18' PM = 'PM' pm = 'pm' TZ = 'MST' ISO8601TZ = 'Z0700' ISO8601SecondsTZ = 'Z070000' ISO8601ShortTZ = 'Z07' ISO8601ColonTZ = 'Z07:00' ISO8601ColonSecondsTZ = 'Z07:00:00' NumTZ = '-0700' NumSecondsTz = '-070000' NumShortTZ = '-07' NumColonTZ = '-07:00' NumColonSecondsTZ = '-07:00:00' FracSecond0= '.0', '.00', ... , FracSecond9 = '.9', '.99', ...,
Here are some examples of custom formats and what input would be expected for December 1st, 2020 at 10:30 PM:
|Custom Format||Expected Input|
|January 01, 2018 03:04:05 PM||December 01, 2020 10:30:00 PM|
|2 Jan 2018 15:04:05||1 Dec 2020 22:30:00|
The following sample workflows are available in our repository’s workflows folder to help you get familiar with this activity. These can be imported using the instructions here or you can view the workflow in GitHub by clicking on it.