Picky Assist Help Desk
Main WebsiteBlogFacebook Community
Picky Assist Help Desk
Picky Assist Help Desk
  • Welcome To Picky Assist 🙏
  • Setting Up Guide
    • Sending First Message
    • Connecting Channels
      • WhatsApp Web Automation to Official API Migration Guide 2024
      • Connecting WhatsApp Web Automation
      • Connecting Facebook Messenger
        • Introduction
        • Getting Start
        • Guidelines & Compliances
        • Messenger Link
      • Connecting WhatsApp Official
        • Introduction
        • Dashboard
        • Profile
        • Templates
      • Connecting WhatsApp Cloud API
      • WhatsApp Official Managed Service
      • Connecting Instagram
      • Phone Bridge (Call Blaze)
      • Connecting SMTP
      • Connecting Amazon SES
      • Connecting Sendgrid
      • Connecting Additional WhatsApp Numbers
      • Porting WhatsApp Number to Picky Assist
      • WhatsApp Official Message Delivery Issues & Solutions
    • Working With Prebuilt CRM Modules
      • Introduction
      • Onboarding
      • Modules
        • Leads
        • Deals
        • Meetings
        • Company
        • Support Cases
        • System Modules
          • Contacts
          • Notes
          • Task
          • Call Logs
          • Tags
          • Activity Logs
      • Automations
        • Workflows
        • Chatbots
        • Funnels
        • Connectors
        • Scheduler
        • Other Prebuilt Features
      • Reports and Dashboard
      • Mandatory Preconditions for Using Prebuilt
      • Testing Prebuilt
    • Managing Organization
    • Setting Up Teambox
      • Introduction
      • Routing Rules
      • Teambox
      • Inbox View
      • Organization Hierarchy
      • Analytics
    • Setting Up Smart Replies
      • Introduction
      • Train Module
        • Training Bot Introduction
        • Topics / Categories
        • Intent & Context
        • Question Variations
        • Uploading Bulk Questions
        • Reply with Media Files
        • Personalising Replies
        • Smart Actions
        • Direct URL
        • Fall Back Response
        • Small Talks
        • Testing the Bot
        • Publishing Bot
      • ChatGPT Integration
      • Learn Module
      • Stats Module
      • Deep Linking
      • Settings
    • Smart Reply V2
      • Introduction
      • ChatGPT Integration
      • Train Module
        • Training Bot Introduction
        • Topics / Categories
        • Intent & Context
        • Question Variation
        • Uploading Bulk Questions
        • Reply with Media Files
        • Personalizing Replies
        • Smart Actions
        • Direct URL
        • Fall Back Response
        • Small Talks
        • Publishing Bot
      • Learn Module
      • Stats Module
      • Deep Linking
      • Settings
    • Setting Up Broadcaster
      • Introduction
      • Creating a Campagin
      • Sending Message to WhatsApp Groups
      • Reports
      • Broadcaster V2
        • Introduction
        • Creating Campaign
        • Reports
    • Setting Up Sequence
      • Introduction
      • Creating New Sequence
      • Sequence Stats
      • Subscribe & Unsubscribe
      • Disabling Sequence Message
    • Setting Up Reminder
    • Setting Up Mobile App
    • Setting Up Connector
      • Introduction
      • Getting Started
      • Steps
        • Introduction
        • Filters
        • Delay
        • Iterator
        • Stats
      • Actions
      • Formatter
        • Date & Time
        • Counter
        • Math Calculation
        • Data Parser
        • Convert File
        • Line Items
      • Building Mini App
      • Email Parser
      • Data Storage
      • Simulate Test
      • Connector Logs
    • Email Builder
    • Setting Up Flow Builder
      • Fundamentals (Must Read)
      • Basic Terminology (Must Read)
      • Guide to Building an Effective Chatbot (Must Read)
      • Create, Manage, Test & Publish Flows
      • Triggering a Chatbot Flow
      • Steps
        • Introduction (Must Read)
        • Send Message
        • Ask A Question
        • Filter
        • Save Data
        • Actions
        • Check WhatsApp Session
        • Delay
        • Smart Delay
        • Formatter
        • Splitter
        • Data Lookup
        • Trigger HTTP API
        • Webhook
        • Apps
        • Match Keywords
        • Route to Chatbot
        • End
      • Saving Data into CRM
      • Analytics
      • Integrations
      • Flow Builder logs and conversational logs
      • Chatbot Best Practices, Ideas & FAQ
    • Setting up Modular CRM
      • Fundamentals (Must Read)
      • Guide to Building and Implementing a Modular CRM (Must Read)
      • Create & Manage Data Modules
      • CRM Macro Buttons
      • Adding Records into CRM
      • Data View & Manage Records
      • Task
      • Workflows
      • Funnels
      • Data Import
      • Integrations
    • Setting Up Scheduler
    • Media Gallery
    • Quick Replies
    • Opt-out Settings
    • Blacklist
    • Global Variables
    • Setting Up Ad-On's
      • Setting Up WhatsMail
      • Setting Up Zendesk
      • Setting Up Zapier
      • Setting Up Zoho CRM
        • Getting Started
        • Working with Extension
        • Integrating with Zoho Workflow
        • Lead Assignment Rules
        • Integrating into Custom Modules
        • Connecting Multiple WhatsApp Numbers into Zoho CRM
        • Integrating WhatsApp with Zoho CRM Mobile App
        • Keyboard Shortcuts
      • Setting Up Facebook Lead Adform
      • Facebook Lead Ad form V2
      • Setting Up WhatsApp Web
      • Setting Up Pabbly Connect
      • Setting Up ChatGPT App
    • Google Chrome Extensions
      • Extension for Sending WhatsApp Messages from any Webpage
      • Chrome Extension V2
      • Extension for Zoho CRM & Teambox
    • Managing Profile
      • Two Factor Aunthentication
      • Login History
      • Delete Account
    • Quick Rollout Guide
      • WhatsApp Official Account
    • Developers & Partners Guide for Deep Integration of Picky Assist
  • API Documentation V2
    • Introduction
    • Quick Start Guide 🏃
    • Global Webhook
      • How Webhook Works
      • Webhook Variables
      • Configuring Webhook URL
      • Webhook Request & Response
      • Getting the Conversation Context
      • Testing Your Webhook
    • Event Webhook
      • How Event Webhook Works
      • Event Webhook Variables
      • Configuring Event Webhook URL
      • Event Webhook Sample Request & Response
    • Push API
      • Introduction
      • API Variables
      • Sending Single Message - Push
      • Sending Dynamic Messages – Push
      • Sending Media Attachments – Push
      • Sending Interactive List & Buttons
      • Sending Stickers
      • Sending Bulk Messages - Push
      • Sending Contacts
      • Sending Location
      • Sending WhatsApp Template Messages
        • Introduction
        • Sending WhatsApp Template Text Messages
        • Sending WhatsApp Template Image
        • Sending WhatsApp Template Document
        • Sending WhatsApp Interactive Buttons
        • Sending WhatsApp Limited Time Offer Templates
      • Sending Message to Groups
      • Sending SMS Using SIM Card
      • Sending Message to Facebook Messenger
      • Normal Post Method
      • Delivery Reports
      • Push API Must Read Instructions
      • Testing API Requests
    • WhatsApp Template API
      • Introduction
      • API Variables
      • Template Request API
      • Template Status API
      • Languages
      • Guidelines
    • WhatsApp Group API
      • Introduction
      • API Variables
      • Create Group
      • Set Group Permission
      • Add Group Admin
      • Add Group Members
      • Fetch Group Details
      • Update Group Info
      • Remove Group Members / Admin
      • Generate New Invite Link
      • Group Delete Actions
    • WhatsApp Settings API's
      • WhatsApp Profile API
      • 2 Step Verification
      • WhatsApp Status Update
      • WhatsApp Contact & Group Fetching
    • Device Manage API’s
      • Fetching Device Status API
      • Device Commands API’s
      • WhatsApp Automation Server Status API
    • Account API
      • Fetch Balance
    • Project Management API
      • Introduction
      • Create Project
      • Get Project Details
      • Set / Update Webhook
      • Create API Token
      • Manage API Token
      • Change Billing Plan
      • Fetch Account Balance
      • Country Code & Timezones
    • References
      • Status & Error Codes
      • Most Frequent Issues & Solutions
      • Formating & Sending Emojis 😊
      • Postman Collection for Picky Assist API's
      • High Volume Messaging Bots - WhatsApp
    • Sample Codes
      • PHP
      • Python
      • Node JS
      • Ruby
      • Java
      • ASP.NET Using C#
      • Javascript
      • Go
      • Swift
      • C
      • C#
      • Objective C
  • General Guidelines
    • Billing
    • Adding Money Into Account
    • Rate Limits
    • Character Limits WhatsApp
    • Best Practices for Media Handling
    • Roadmap
    • Features In the Early Beta Version
  • Changelog
    • 2021
      • February 2021
      • March 2021
      • April 2021
      • May 2021
      • June 2021
    • 2020
      • February 2020
      • March 2020
      • April 2020
      • May 2020
      • June 2020
      • September 2020
      • October 2020
    • 2019
      • November 2019
      • October 2019
      • August 2019
      • September 2019
Powered by GitBook
On this page
  • Date & Time
  • Adding or Subtracting Days from a Date
  • Transforming Date From One Format To Another
  • Convert To Another Timezone

Was this helpful?

  1. Setting Up Guide
  2. Setting Up Connector
  3. Formatter

Date & Time

Transfer Date & Time from One Format to another with Connector

PreviousFormatterNextCounter

Last updated 3 months ago

Was this helpful?

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.

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

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)

Pick from commonly used date formats or customize the format according to your needs.

Click here to read more.