Assistants need to reach this page over the internet. While it is only running on your machine, these two buttons will not be able to load it.
Each image has a one line explanation. Switch to full detail for the step it belongs to, the fields and buttons involved, examples and the whole procedure.
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.
TABLE OF CONTENTS
Format Date
Format Date and Time
Compare Dates
Figure 1What this shows Format Date Format Date and Time Compare DatesWhat this showsIllustrates "Workflow - Date/Time Formatter Action".This screenshot appears in "Workflow - Date/Time Formatter Action". The text alongside this image reads: Format Date Format Date and Time Compare Dates. This part of the guide covers 3 fields, listed below. Immediately after, the guide continues: Select any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even Inbound Webhook Trigger.Image 1 of 14What this coversFormat Date Format Date and Time Compare Dates
Fields in this part of the guideFormat DateFormat Date and TimeCompare Dates
Buttons and menus referencedTABLE OF CONTENTS
Next stepSelect any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even Inbound Webhook Trigger.All 3 steps in this procedure
Format Date
Format Date and Time
Compare Dates
How to Format a Date
To convert date structure from one format to another. Field:
Select any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even Inbound Webhook Trigger.
From Format: (image 2 of 14)What this shows Select any date field.What this showsIllustrates the "From Format:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "From Format:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Select any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even Inbound Webhook Trigger. Immediately after, the guide continues: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom….Image 2 of 14What to fill inSelect any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even Inbound Webhook Trigger.Next stepSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.From Format:
Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
From Format: (image 3 of 14)What this shows Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or…What this showsIllustrates the "From Format:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "From Format:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to….Image 3 of 14What to fill inSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
To Format:
Select the required format from the list
Select the required format from the list (image 4 of 14)What this shows Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or…What this showsIllustrates the "Select the required format from the list" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Select the required format from the list" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to…. Immediately after, the guide continues: To convert date and time structure from one format to another.Image 4 of 14What to fill inSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.Next stepTo convert date and time structure from one format to another
Output
After setting up the Format Date, you can use the results in further actions in your Workflow {{datetime_formatter.1.date}}
Custom Values
Custom Values (image 5 of 14)What this shows Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or…What this showsIllustrates the "Custom Values" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Custom Values" section of "Workflow - Date/Time Formatter Action". For context, this section explains: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to…. Immediately after, the guide continues: To convert date and time structure from one format to another.Image 5 of 14Next stepTo convert date and time structure from one format to another
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.
Please note:
Currently, Contact Custom fields do not support the Date Time structure.
Field: (image 6 of 14)What this shows Currently, Contact Custom fields do not support the Date Time structure.What this showsIllustrates the "Field:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Field:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Currently, Contact Custom fields do not support the Date Time structure. Immediately after, the guide continues: Selecting any system fields like Specific Date and Time, Current Date and Time, Contact fields, or Appointment start or end date time will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook….Image 6 of 14What this coversCurrently, Contact Custom fields do not support the Date Time structure.Next stepSelecting any system fields like Specific Date and Time, Current Date and Time, Contact fields, or Appointment start or end date time will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
From Format:
Selecting any system fields like Specific Date and Time, Current Date and Time, Contact fields, or Appointment start or end date time will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
From Format: (image 7 of 14)What this shows Selecting any system fields like Specific Date and Time, Current Date and Time, Contact fields, or Appointment start or end date time will…What this showsIllustrates the "From Format:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "From Format:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Selecting any system fields like Specific Date and Time, Current Date and Time, Contact fields, or Appointment start or end date time will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format. Immediately after, the guide continues: Select the required format from the list.Image 7 of 14What to chooseSelecting any system fields like Specific Date and Time, Current Date and Time, Contact fields, or Appointment start or end date time will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.Next stepSelect the required format from the list
To Format:
Select the required format from the list
To Format: (image 8 of 14)What this shows Select the required format from the listWhat this showsIllustrates the "To Format:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "To Format:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Select the required format from the list. Immediately after, the guide continues: After setting up the Format Date and Time, you can use the results in further actions in your Workflow.Image 8 of 14What to chooseSelect the required format from the listNext stepAfter setting up the Format Date and Time, you can use the results in further actions in your Workflow.
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
Output (image 9 of 14)What this shows {{datetime_formatter.1.datetime}}What this showsIllustrates the "Output" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Output" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: {{datetime_formatter.1.datetime}}. For context, this section explains: After setting up the Format Date and Time, you can use the results in further actions in your Workflow. Immediately after, the guide continues: Compare two dates and get the difference in the number of days.Image 9 of 14What this covers{{datetime_formatter.1.datetime}}Next stepCompare two dates and get the difference in the number of days
Compare Dates
Compare two dates and get the difference in the number of days
Start Date:
Select any date field. You can select a Specific Date, or 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: (image 10 of 14)What this shows Select any date field.What this showsIllustrates the "Start Date:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Start Date:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Select any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even from Inbound Webhook Trigger. Immediately after, the guide continues: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom….Image 10 of 14What to fill inSelect any date field. You can select a Specific Date, or Current Date, from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even from Inbound Webhook Trigger.Next stepSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
Start Date Format:
Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
Start Date Format: (image 11 of 14)What this shows Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or…What this showsIllustrates the "Start Date Format:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Start Date Format:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to…. Immediately after, the guide continues: Select any date field. You can select a Specific Date or Current Date from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even an Inbound Webhook Trigger.Image 11 of 14What to fill inSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.Next stepSelect any date field. You can select a Specific Date or Current Date from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even an Inbound Webhook Trigger.
End Date:
Select any date field. You can select a Specific Date or Current Date from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even an Inbound Webhook Trigger.
End Date: (image 12 of 14)What this shows Select any date field.What this showsIllustrates the "End Date:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "End Date:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Select any date field. You can select a Specific Date or Current Date from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even an Inbound Webhook Trigger. Immediately after, the guide continues: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom….Image 12 of 14What to fill inSelect any date field. You can select a Specific Date or Current Date from Contact's date fields or date type custom fields, Appointment start/end date, Custom values, or even an Inbound Webhook Trigger.Next stepSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
End Date Format:
Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.
End Date Format: (image 13 of 14)What this shows Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or…What this showsIllustrates the "End Date Format:" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "End Date Format:" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: Selecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to…. Immediately after, the guide continues: After setting up the Compare Dates, you can use the results in further actions in your Workflow. {{datetime_formatter.1.days}}.Image 13 of 14What to fill inSelecting system fields like Specific Date, Current Date, from Contact's date type standard fields, Contact's date type custom fields, or Appointment start or end date will auto-detect the format and preselect the same. If it is a Custom Value or from an Inbound Webhook trigger, you will have to select the exact matching format.Next stepAfter setting up the Compare Dates, you can use the results in further actions in your Workflow. {{datetime_formatter.1.days}}
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 you will get a negative value if the Start Date is greater than the End Date.
Custom Values
Output (image 14 of 14)What this shows The difference is calculated as End Date - Start Date, so you will get a negative value if the Start Date is greater than the End Date.What this showsIllustrates the "Output" section of "Workflow - Date/Time Formatter Action".This screenshot appears in the "Output" section of "Workflow - Date/Time Formatter Action". The text alongside this image reads: The difference is calculated as End Date - Start Date, so you will get a negative value if the Start Date is greater than the End Date. Immediately after, the guide continues: Format the Inbound Webhook Trigger data to Set Event Start Date, to update Contact Custom Fields, to compare in If/Else Condition. Let's say the date format is MM/DD/YYYY, but you need to send it to an app that formats dates as….Image 14 of 14What this coversThe difference is calculated as End Date - Start Date, so you will get a negative value if the Start Date is greater than the End Date.Next stepFormat the Inbound Webhook Trigger data to Set Event Start Date, to update Contact Custom Fields, to compare in If/Else Condition. Let's 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 the Current date(Start Date) with the 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, Please Note:
Usage
Format the Inbound Webhook Trigger data to Set Event Start Date, to update Contact Custom Fields, to compare in If/Else Condition.
Let's 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 the Current date(Start Date) with the 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, Please 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 a negative value
