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

Please note the Custom Timezone the data should be in the Global Format to work.

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