Link Search Menu Expand Document

Format Date

This activity allows you to convert a datetime to various different pre-defined or custom formats. This is often used when an API requires datetimes to be in a specific format that’s different than the native format SecureX orchestration uses.


Usage

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 Original Datetime to convert to a different format. You can provide this date as a string (in a supported format) or from a Date Time variable.

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).


Hints

  • When using the variable browser to use this activity’s output, be careful which variable you select. Every activity has a Start time and End time which represent when the activity itself started and stopped running. The output from the activity is actually in the Result variable.

Supported Date Formats

The following datetime formats can be used as input into this activity. You can also use a Date Time variable.

ANSIC = 'Mon Jan 2 15:04:05 2018'
UnixDate = 'Mon Jan 2 15:04:05 MST 2018'
RubyDate = 'Mon Jan 02 15:04:05 -0700 2018'
RFC822 = '02 Jan 18 15:04 MST'
RFC822Z = '02 Jan 18 15:04 -0700'
RFC850 = 'Monday, 02-Jan-18 15:04:05 MST'
RFC1123 = 'Mon, 02 Jan 2018 15:04:05 MST'
RFC1123Z = 'Mon, 02 Jan 2018 15:04:05 -0700'
RFC3339 = '2018-01-02T15:04:05-07:00'
RFC3339Nano = '2018-01-02T15:04:05.999999999-07:00'
Custom formats:
'2018-01-02'
'02-01-2018'
'20180102-150405'
'02012018-150405 (Europe time format)'
Please notice that '01' always stands for Month and '02' stands for Day."

Custom Datetime Formats

If you want to define your own datetime output 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 the result would be for December 1st, 2020 at 10:30 PM:

Custom Format Result
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
01-02-2018 12-01-2020
15:04:05 22:30:00

Sample Workflows

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.