Date/Time Formatter Premium Action
With the Date/Time Formatter action, you can reformat the Date or Date and Time as per your requirement. You can also compare dates using the action.
Format Date
Format Date and Time
Compare Dates
Format Date
To convert date structure from one format to another.
Field:
Select any date field, you can select a Specific Date, Current Date, from Contact’s date fields or date type custom fields, Appointment start/end date, Custom values or even from Inbound Webhook Trigger.
From Format:
If you select any of the system fields like Specific Date, Current Date, from Contact’s date type standard fields, Contact’s date type custom fields, Appointment start or end date it will auto detect the format and preselect the same. If it is a Custom Value or from Inbound Webhook trigger you will have to select the exact matching format.
To Format:
Select the required format from the list
Output
After setting up the Format Date, you can use the results in further actions in your Workflow.
{{datetime_formatter.1.date}}
Custom Values
Format Date and Time
To convert date and time structure from one format to another
Field:
Select any date time field, you can select a Specific Date and Time, Current Date and Time, Appointment start or end date time, Custom values or even from Inbound Webhook Trigger.
Currently Contact Custom fields does not support Date Time structure.
From Format:
If you select any of the system fields like Specific Date and Time, Current Date and Time, Contact fields, Appointment start or end date time it will auto detect the format and preselect the same. If it is a Custom Value or from Inbound Webhook trigger you will have to select the exact matching format.
To Format:
Select the required format from the list
Output
After setting up the Format Date and Time, you can use the results in further actions in your Workflow.
{{datetime_formatter.1.datetime}}
Custom Values
Compare Dates
Compare two dates and get the difference in number of days
Start Date:
Select any date field, you can select a Specific Date, Current Date, from Contact’s date fields or date type custom fields, Appointment start/end date, Custom values or even from Inbound Webhook Trigger.
Start Date Format:
If you select any of the system fields like Specific Date, Current Date, from Contact’s date type standard fields, Contact’s date type custom fields, Appointment start or end date it will auto detect the format and preselect the same. If it is a Custom Value or from Inbound Webhook trigger you will have to select the exact matching format.
End Date:
Select any date field, you can select a Specific Date, Current Date, from Contact’s date fields or date type custom fields, Appointment start/end date, Custom values or even from Inbound Webhook Trigger.
End Date Format:
If you select any of the system fields like Specific Date, Current Date, from Contact’s date type standard fields, Contact’s date type custom fields, Appointment start or end date it will auto detect the format and preselect the same. If it is a Custom Value or from Inbound Webhook trigger you will have to select the exact matching format.
Output
After setting up the Compare Dates, you can use the results in further actions in your Workflow. {{datetime_formatter.1.days}}
The difference is calculated as End Date - Start Date, so if the Start Date is greater than the End Date you will get negative value.
Custom Values
Usage
Format the Inbound Webhook Trigger data to Set Event Start Date, to update Contact Custom Fields, to compare in If/Else Condition
Lets say the date format is MM/DD/YYYY but you need to send it to an app that formats dates as DD/MM/YYYY, you can use the Date/Time Formater to change the date format and send it via Custom Webhook.
Store the custom formatted date time info in Google Sheets
Use the custom formatted date time info in Email/SMS/Slack
Compare Current date(Start Date) with Invoice Due date(End Date) and use the dynamic value in Email/SMS/Slack,
Eg: Your Invoice is due in {{datetime_formatter.1.days}} days,
Note: On overdue, that is when Current Date(Start Date) is greater than the Invoice Due Date(End Date) you will get the result in negative value
Last updated
