Date & Time

Transfer Date & Time from One Format to another with Connector

Date & Time

Date & Time formatter helps you to transform the date from one format to another as well it's possible to add or subtract days from a date

Go to Formatter -> Select Formatter Type -> Date & Time

Select Action Type as shown below

Adding or Subtracting Days from a Date

It's possible to add or subtract days from a given date which helps to find a future or past date like adding 3 will add 3 days more from the given date similarly by giving -2 will reduce 2 days from the given date

This is helpful for lot of usecases for an example you have an invoice generated in a Google Sheet and want to automatically include the due date while sending a WhatsApp message, for this just add 15 days from the given date and assign the new date into a variable and use that variable while compose a WhatsApp Message

The system will automatically add 15 days more and show the due date correctly to the customer.

Select Field to Format

You need to select the field which you want to format, click on the Attribute in the right side to select the field from the 3rd party apps

Please make sure this field is a date always

Map Date & Time

When you selected the date field then you will able to see an option to "Map Date & Time" format this helps our system to make sure that the date and time is in correct format, by default our system automatically identify all standard date formats including timestamps however in certain cases if we don't identify the date then you need to map the date correctly using this tool

For an example in your Google Sheet the date is stored as 06/6/98 here the system will get confused to find which 6th is day and month, so in this case you need to manually tell the system that 06 is month and 6 is day.

Selecting the Timezone

Select the Timezone in which the date is, if you want to dynamically change the timezone based on each user's profile then you can use the Custom option then select a variable in which the Timezone is available

Enter Days

This is where you need to enter the days to which the Date should be converted, if you want to add 10 days from the given value then simply add "10"

If you want minus 7 days from given value then prefix minus like -7

Storing the Converted Value to a Variable

Now you need to give a name to store the converted value and our system will store the converted value into this variable and you will have the option to use this in other steps or actions wherever needed

Testing the Configuration

After configuring all the required fields you will able to click on "Test" button to see the results

Please note the test result will work only if sample value is available in selected variable

Using the Formatted Results in Attributes

All the formatted results are available in the Stored Value with the name you have given for it, you can select the "Attribute" wherever you want to use this, you need to select the "Formatter" to list all your active formatters

Transforming Date From One Format To Another

Using the "Transform Date" formatter tool you will able to transform a date and time into another format or virtually to any format you like to use.

Example : 2021-03-25 21:26:42 -> 25, Mar 2021 9:26:42 PM

Select Formatter Type as "Date & Time" then Select Action Type as "Transform Date" as shown below

Select Field to Format

You need to select the field which you want to format, click on the Attribute in the right side to select the field from the 3rd party apps

Please make sure this field is a date always

Select Map Date & Time then Select the TimeZone as per the above steps

Select Pretty Format

This where you convert the date to another format as per your requirements, we have listed most commonly used formats so that you can easily select one however you are free to make changes the way you needed.

To make change of the existing format you can see all the possible date and time variables by clicking the attribute section as shown below ;

List of Available Date & Time Shortcodes

Shortcode

Description

Example

Year

YYYY

2021

Year

YY

21

Month

MMMM

June

Month

MMM

Jun

Month

MM

06

Month

M

6

Day of Year

DDDD

046

Day of Year

DDD

46

Day of Week

dddd

Monday

Day of Week

ddd

Mon

Day of Week

d

1

Hour

HH

03

Hour

H

3

AM / PM

AM

AM

am / pm

am

am

Minute

mm

35

Seconds

ss

35

Second

s

06

Timestamp

x

1381685817

Using the Date & Time Shortcodes you can customise the data and time the way you want to, you can put any data as a seperator like DD/MM -> YYYY or YY/MM/YY

Storing the Converted Value to a Variable

Now you need to give a name to store the converted value and our system will store the converted value into this variable and you will have the option to use this in other steps or actions wherever needed

Testing the Configuration

After configuring all the required fields you will able to click on "Test" button to see the results

Please note the test result will work only if sample value is available in selected variable

Using the Formatted Results in Attributes

All the formatted results are available in the Stored Value with the name you have given for it, you can select the "Attribute" wherever you want to use this, you need to select the "Formatter" to list all your active formatters.

Convert To Another Timezone

The Convert to Timezone feature will allow you to easily convert date and time values from one timezone to another, ensuring accurate scheduling, reporting, and global operations.

This feature is particularly helpful for businesses operating across different time zones, ensuring that time-sensitive tasks like follow-up actions, meeting scheduling, and customer service responses are handled correctly and on time, no matter where your team or customers are located. It's a vital tool for businesses that need to coordinate across multiple regions and manage tasks based on precise timing.

For example, a company is hosting a webinar in India (IST), and participants have registered from different countries. They need to receive the webinar time in their respective time zones. With the Convert to Timezone feature, the system automatically converts the webinar time into each participant’s local timezone, ensuring that everyone receives the correct time for the webinar.

Setting up

Select Formatter Type as "Date & Time" then Select Action Type as "Convert to Another Timezone" as shown below

Select Field to Format

Choose the date field you want to format. You can either enter the date manually or map it dynamically.

Map Date & Time

Ensure the date is in the correct format. If the system doesn’t automatically detect the date format, you can manually map it to the correct one.

Timezone

Select the timezone corresponding to the date you’ve entered or mapped. If you need the timezone to change dynamically, use the Custom option and map it to the appropriate variable.

(See the below picture)

Timezone to Convert

Choose the timezone you want to convert the date and time to. If necessary, you can dynamically map the timezone by clicking the map timezone dynamically option.

Select Pretty Format

Pick from commonly used date formats or customize the format according to your needs. Click here to read more.

Storing the Converted Value to a Variable

Store the formatted date and time into a variable. This variable can then be used in other steps or actions within the process. You can use the stored, formatted result in other steps by selecting the "Formatter" and choosing the stored value for further processing.

Testing the Configuration

Click the “Test” button to verify that the configuration works correctly. The test results will only be available if a sample value exists in the selected variable.

(See the below picture)

Last updated

Was this helpful?