Open Navigation

Date & Time Helpers

The Date & Time helpers allow you to manipulate date and time values of various formats from connectors and triggers.

Overview

The Date & Time helpers allow you to manipulate date and time values of various formats from connectors and triggers. These are commonly used for tasks such as converting date/time values to different formats, or finding the difference between two date & time values.


Examples


Getting the current day of the week

Step 1 - Get the current date and time

In this example, we'll be getting the current day of the week. The first thing we need to do is establish the current date and time.

Start by dragging the Date & Time Helpers helper to a workflow and select Get current timestamp from the operation dropdown.

date-time-helper-example1.1

We'll use the default timezone (UTC) but you could select any timezone from the dropdown combo based on your own requirements.

Step 2 - Get the day of the week

Next, we'll use the current date and time from step 1 to get the current day of the week.

Drag the Date & Time Helpers helper to the workflow and select Get day of week from the operation dropdown.

date-time-helper-example1.2.1

Now connect the Date & time input of the Get day of week operation to the output of step 1 by using the Connector Snake.

date-time-helper-example1.2.2

The Get day of week operation will take the current date and time from step 1 and work out the day of the week. Again, select the Timezone that you wish to work in. We are keeping everything in UTC for this example.

You should now have a workflow that looks like this with the Date & time populated with the json path of the step 1 output $.steps.date-time-helpers-1.result:

date-time-helper-example1.2.3

All we need to do now is run the worflow...

Step 3 - Run the workflow

Once the workflow has executed, you will be able to see the input and output of the Get day of week operation in the debug panel.

date-time-helper-example1.3

As you can see, the date/time and timezone were passed as inputs and the operation calculated the day of the week as Wednesday for the operation output.


Formatting the date

A date string or timestamp can be formatted into a particular style of writing using the Format date operation of the Date & Time Helpers connector. For instance, '2006-01-22' is represented by YYYY-MM-DD, while 'Sun, January 22nd 2006' is represented by ddd, MMMM Do YYYY.

Date and Times can be represented in any way you want by combining the variables in the following table.

TokenOutput
YearYY70 71 ... 29 30
YYYY1970 1971 ... 2029 2030
QuarterQ1 2 3 4
Qo1st 2nd 3rd 4th
MonthM1 2 ... 11 12
Mo1st 2nd ... 11th 12th
MM01 02 ... 11 12
MMMJan Feb ... Nov Dec
MMMMJanuary February ... November December
Week of YearW1 2 ... 52 53
Wo1st 2nd ... 52nd 53rd
WW01 02 ... 52 53
Day of YearDDD1 2 ... 364 365
DDDo1st 2nd ... 364th 365th
DDDD001 002 ... 364 365
Day of MonthD1 2 ... 30 31
Do1st 2nd ... 30th 31st
DD01 02 ... 30 31
Day of Weekd0 1 ... 5 6
E1 2 ... 6 7
do0th 1st ... 5th 6th
ddSu Mo ... Fr Sa
dddSun Mon ... Fri Sat
ddddSunday Monday ... Friday Saturday
AM/PMAAM PM
aam pm
HourH0 1 ... 22 23
HH00 01 ... 22 23
h1 2 ... 11 12
hh01 02 ... 11 12
k1 2 ... 23 24
kk01 02 ... 23 24
Minutem0 1 ... 58 59
mm00 01 ... 58 59
Seconds0 1 ... 8 9
ss00 01 ... 58 59
Fractional SecondS0 1 ... 8 9
SS00 01 ... 98 99
SSS000 0001 ... 998 999
SSSS ... SSSSSSSSS000[0..] 001[0..] ... 998[0..] 999[0..]
Time Zonez or zzEST CST ... MST PST
Z-07:00 -06:00 ... +06:00 +07:00
ZZ-0700 -0600 ... +0600 +0700
Unix TimestampX1360013296
Unix Millisecond Timestampx1360013296123
Was this article helpful?
Yes
No