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
andEnd time
which represent when the activity itself started and stopped running. The output from the activity is actually in theResult
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.