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
Last updated
