Workflow - 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