Converting dates in Integromat

Handling dates in Integromat

Knowledge Level: Advanced

When working with webhooks, you will come across scenarios where you are using dates. Dates are handled in two ways via The Bot Platform:

  • The webhook contains a unix timestamp which represents the time at which the webhook was inititated
  • bot user inputs date which is captured through an attribute in the platform and passed on through a webhook.

In the below steps, we will demonstrate a few examples which you can use to convert dates to various different formats using Integromat.

Converting unix timestamp to user human readable format

Let's see this example below. We have a webhook with the 'timestamp' in Unix time format:

Note: A unix time stamp is a way to track the time as a running total of seconds, this count starts at the Unix Epoch on January 1st, 1970 at UTC.

442442

To convert this to a date in human readable format, we will use one of Integromat's date operator.

You will find these operators when adding webhook data to another data point such as a Google Sheet.

For conversion, the formula will look like this:

776776

Using the 'fomratDate' operator, we parse the 'timestamp' from our webhook and define an output format.

In this case, we used the format 'DD/MM/YYY' as output.

When the scenario runs successfully, the output in your Google Sheet will show as below:

242242

Add or subtract days in Integromat

Similar to the above scenario, we can perform calculations on a date entered by the bot user.

For example, we can add two days to a date entered by the bot user and submit the output to a Google sheet.

See example below:

414414

In the above example, we first formatted the date to our preferred format i.e DD/MM/YYY, after formatting we used the operator 'addDays' to add two additional days to the actual date.

Our output in Google Sheet can be seen below:

318318