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.
The Date/Time Formatter action is a versatile tool that allows users to reformat and compare dates or date-times within workflows. This feature enables easy conversion of date formats for compatibility with different applications, database storage, or communication channels like email, SMS, or Slack. It also facilitates the comparison of dates to calculate the difference in days, simplifying date-related calculations and decision-making.
The Date/Time Formatter action is a simple tool that helps you work with dates and times in your automated tasks. Here are the three main features and their steps:
Changing the format of dates (ex: 2024-12-09)
Changing the format of date-times (ex: 2024-12-09 15:48)
Comparing two dates to see their difference (ex: 2024-12-09 vs 2024-12-08)
With these features, you can easily change how dates and times look or compare two dates, making it simple to share or save information in the correct format.
Key Benefits of Date/Time Formatter Action
The Date/Time Formatter action offers several benefits for users who need to work with date and time data in their workflows:
Consistency: Ensures date and time data is formatted uniformly across different platforms and applications, improving readability and reducing confusion.
Compatibility: Facilitates seamless data exchange and integration between various tools and systems by converting date and time formats as needed.
Decision-making: Simplifies date comparisons and calculations, supporting informed decision-making in time-sensitive operations.
Flexibility: Offers a wide range of format options to cater to specific requirements or preferences, making it adaptable to various use cases.
How To Setup Date/Time Formatter Action
Access Workflow Builder
Go to Automation > Create Workflow> + Start from Scratch. Alternatively, you can choose any of your existing workflow to use the Date/Time Formatter workflow action.
Access Workflow Builder (image 1 of 13)What this shows Go to Automation > Create Workflow> + Start from Scratch.What this showsIllustrates the "Access Workflow Builder" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Access Workflow Builder" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Go to Automation > Create Workflow> + Start from Scratch. Alternatively, you can choose any of your existing workflow to use the Date/Time Formatter workflow action. The navigation path used here is Automation > Create Workflow. Immediately after, the guide continues: Click the "+" icon to view the list of workflow actions, seect "Date/Time Formatter" from the list.Path: Automation > Create WorkflowImage 1 of 13Where to goGo to Automation > Create Workflow> + Start from Scratch. Alternatively, you can choose any of your existing workflow to use the Date/Time Formatter workflow action.Next stepClick the "+" icon to view the list of workflow actions, seect "Date/Time Formatter" from the list.
Select Date/Time Formatter Action
Click the "+" icon to view the list of workflow actions, seect "Date/Time Formatter" from the list.
Select Date/Time Formatter Action (image 2 of 13)What this shows Click the "+" icon to view the list of workflow actions, seect "Date/Time Formatter" from the list.What this showsIllustrates the "Select Date/Time Formatter Action" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Select Date/Time Formatter Action" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Click the "+" icon to view the list of workflow actions, seect "Date/Time Formatter" from the list. Immediately after, the guide continues: The Date/Time Formatter action ensures workflows can properly format, store, and compare date values for automation. Once configured, it stores the reformatted or calculated values as dynamic variables, which can be used in later workflow….Image 2 of 13What to clickClick the "+" icon to view the list of workflow actions, seect "Date/Time Formatter" from the list.Next stepThe Date/Time Formatter action ensures workflows can properly format, store, and compare date values for automation. Once configured, it stores the reformatted or calculated values as dynamic variables, which can be used in later workflow actions like sending emails, updating CRM fields, or triggering conditional workflows. With the Date/Time Formatter action, you can also compare dates using the action.
Understanding Different Action Types
The Date/Time Formatter action ensures workflows can properly format, store, and compare date values for automation. Once configured, it stores the reformatted or calculated values as dynamic variables, which can be used in later workflow actions like sending emails, updating CRM fields, or triggering conditional workflows. With the Date/Time Formatter action, you can also compare dates using the action.
There are three primary ways to use this action:
Format Date: Convert a date into a different format.
Format Date-Time: Change both date and time formatting.
Compare Dates: Calculate the difference between two dates.
Understanding Different Action Types (image 3 of 13)What this shows Format Date: Convert a date into a different format.What this showsIllustrates the "Understanding Different Action Types" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Understanding Different Action Types" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Format Date: Convert a date into a different format. Format Date-Time: Change both date and time formatting. Compare Dates: Calculate the difference between two dates. Immediately after, the guide continues: The Format Date function is a crucial feature of the Date/Time Formatter action, specifically designed to convert date structures from one format to another. Here's a more detailed breakdown of the Format Date function.Image 3 of 13What this coversFormat Date: Convert a date into a different format. Format Date-Time: Change both date and time formatting. Compare Dates: Calculate the difference between two dates.Next stepThe Format Date function is a crucial feature of the Date/Time Formatter action, specifically designed to convert date structures from one format to another. Here's a more detailed breakdown of the Format Date function:All 3 steps in this procedure
Format Date: Convert a date into a different format.
Format Date-Time: Change both date and time formatting.
Compare Dates: Calculate the difference between two dates.
Format DATE
The Format Date function is a crucial feature of the Date/Time Formatter action, specifically designed to convert date structures from one format to another. Here's a more detailed breakdown of the Format Date function:
Field Selection
Choose the date field you want to reformat. You can select various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or even from an Inbound Webhook Trigger.
Field Selection (image 4 of 13)What this shows Choose the date field you want to reformat.What this showsIllustrates the "Field Selection" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Field Selection" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Choose the date field you want to reformat. You can select various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or even from an Inbound Webhook Trigger. Immediately after, the guide continues: Currently, Contact Custom fields do not support the Date Time structure.Image 4 of 13What to fill inChoose the date field you want to reformat. You can select various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or even from an Inbound Webhook Trigger.Next stepCurrently, Contact Custom fields do not support the Date Time structure.
Currently, Contact Custom fields do not support the Date Time structure.
From Format
If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.
From Format (image 5 of 13)What this shows If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end…What this showsIllustrates the "From Format" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "From Format" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger. Immediately after, the guide continues: Select the desired format for the output date from the list of available formats. This is the format the original date will be converted to.Image 5 of 13What to fill inIf you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.Next stepSelect the desired format for the output date from the list of available formats. This is the format the original date will be converted to.
To Format
Select the desired format for the output date from the list of available formats. This is the format the original date will be converted to.
To Format (image 6 of 13)What this shows Select the desired format for the output date from the list of available formats.What this showsIllustrates the "To Format" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "To Format" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Select the desired format for the output date from the list of available formats. This is the format the original date will be converted to. Immediately after, the guide continues: The Format date-time function is an essential feature of the Date/Time Formatter action, designed to convert structures that include both date and time information to a different format. Here's a more detailed explanation of the Format….Image 6 of 13What to chooseSelect the desired format for the output date from the list of available formats. This is the format the original date will be converted to.Next stepThe Format date-time function is an essential feature of the Date/Time Formatter action, designed to convert structures that include both date and time information to a different format. Here's a more detailed explanation of the Format Date and Time function:
Format DATE-TIME
The Format date-time function is an essential feature of the Date/Time Formatter action, designed to convert structures that include both date and time information to a different format. Here's a more detailed explanation of the Format Date and Time function:
Field Selection
Choose the date and time field you want to reformat. You can select various sources such as a Specific Date and Time, Current Date and Time, Appointment start/end date and time, Custom values, or even from an Inbound Webhook Trigger. Note that Contact Custom fields do not currently support Date Time structures.
Field Selection (image 7 of 13)What this shows Choose the date and time field you want to reformat.What this showsIllustrates the "Field Selection" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Field Selection" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Choose the date and time field you want to reformat. You can select various sources such as a Specific Date and Time, Current Date and Time, Appointment start/end date and time, Custom values, or even from an Inbound Webhook Trigger. Note that Contact Custom fields do not currently support Date…. Immediately after, the guide continues: Currently, Contact Custom fields do not support the Date Time structure.Image 7 of 13What to chooseChoose the date and time field you want to reformat. You can select various sources such as a Specific Date and Time, Current Date and Time, Appointment start/end date and time, Custom values, or even from an Inbound Webhook Trigger. Note that Contact Custom fields do not currently support Date Time structures.Next stepCurrently, Contact Custom fields do not support the Date Time structure.
Currently, Contact Custom fields do not support the Date Time structure.
From Format:
The tool will auto-detect the format and preselect if you select a system field like Specific Date and Time, Current Date and Time, or Appointment start/end date and time. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.
From Format: (image 8 of 13)What this shows The tool will auto-detect the format and preselect if you select a system field like Specific Date and Time, Current Date and Time, or…What this showsIllustrates the "From Format:" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "From Format:" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: The tool will auto-detect the format and preselect if you select a system field like Specific Date and Time, Current Date and Time, or Appointment start/end date and time. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger. Immediately after, the guide continues: Select the desired output date and time format from the list of available formats. This is the format the original date and time will be converted to.Image 8 of 13What to chooseThe tool will auto-detect the format and preselect if you select a system field like Specific Date and Time, Current Date and Time, or Appointment start/end date and time. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.Next stepSelect the desired output date and time format from the list of available formats. This is the format the original date and time will be converted to.
To Format
Select the desired output date and time format from the list of available formats. This is the format the original date and time will be converted to.
To Format (image 9 of 13)What this shows Select the desired output date and time format from the list of available formats.What this showsIllustrates the "To Format" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "To Format" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Select the desired output date and time format from the list of available formats. This is the format the original date and time will be converted to. Immediately after, the guide continues: The Compare Dates function is a valuable feature of the Date/Time Formatter action that allows users to compare two dates and obtain the difference in days. Here's a detailed overview of the Compare Dates function.Image 9 of 13What to chooseSelect the desired output date and time format from the list of available formats. This is the format the original date and time will be converted to.Next stepThe Compare Dates function is a valuable feature of the Date/Time Formatter action that allows users to compare two dates and obtain the difference in days. Here's a detailed overview of the Compare Dates function:
Compare Dates
The Compare Dates function is a valuable feature of the Date/Time Formatter action that allows users to compare two dates and obtain the difference in days. Here's a detailed overview of the Compare Dates function:
Start Date Selection
Choose the start date from various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or an Inbound Webhook Trigger.
Start Date Selection (image 10 of 13)What this shows Choose the start date from various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields…What this showsIllustrates the "Start Date Selection" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Start Date Selection" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Choose the start date from various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or an Inbound Webhook Trigger. Immediately after, the guide continues: If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching….Image 10 of 13What to fill inChoose the start date from various sources such as a Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or an Inbound Webhook Trigger.Next stepIf you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.
Start Date Format
If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.
Start Date Format (image 11 of 13)What this shows If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end…What this showsIllustrates the "Start Date Format" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "Start Date Format" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: If you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger. Immediately after, the guide continues: Choose the end date from the same sources as the start date (Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or from an Inbound Webhook Trigger).Image 11 of 13What to fill inIf you select a system field like Specific Date, Current Date, Contact's date type standard or custom fields, or Appointment start/end date, the tool will auto-detect the format and preselect it. You must manually select the matching format if you choose a Custom Value or an Inbound Webhook Trigger.Next stepChoose the end date from the same sources as the start date (Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or from an Inbound Webhook Trigger).
End Date Selection
Choose the end date from the same sources as the start date (Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or from an Inbound Webhook Trigger).
End Date Selection (image 12 of 13)What this shows Choose the end date from the same sources as the start date (Specific Date, Current Date, Contact's date fields, date type custom fields…What this showsIllustrates the "End Date Selection" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "End Date Selection" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Choose the end date from the same sources as the start date (Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or from an Inbound Webhook Trigger). Immediately after, the guide continues: Like the start date format, the tool will auto-detect the format and preselect it if you choose a system field. You must manually select the matching format for Custom Value or Inbound Webhook Trigger.Image 12 of 13What to fill inChoose the end date from the same sources as the start date (Specific Date, Current Date, Contact's date fields, date type custom fields, Appointment start/end date, Custom values, or from an Inbound Webhook Trigger).Next stepLike the start date format, the tool will auto-detect the format and preselect it if you choose a system field. You must manually select the matching format for Custom Value or Inbound Webhook Trigger.
End Date Format
Like the start date format, the tool will auto-detect the format and preselect it if you choose a system field. You must manually select the matching format for Custom Value or Inbound Webhook Trigger.
End Date Format (image 13 of 13)What this shows Like the start date format, the tool will auto-detect the format and preselect it if you choose a system field.What this showsIllustrates the "End Date Format" section of "Guide to Date/Time Formatter Workflow Action".This screenshot appears in the "End Date Format" section of "Guide to Date/Time Formatter Workflow Action". The text alongside this image reads: Like the start date format, the tool will auto-detect the format and preselect it if you choose a system field. You must manually select the matching format for Custom Value or Inbound Webhook Trigger. Immediately after, the guide continues: The difference is calculated as End Date - Start Date. You will get a negative value if the Start Date exceeds the End Date. The Compare Dates function is beneficial for users who need to perform date comparisons for various purposes….Image 13 of 13What to chooseLike the start date format, the tool will auto-detect the format and preselect it if you choose a system field. You must manually select the matching format for Custom Value or Inbound Webhook Trigger.Next stepThe difference is calculated as End Date - Start Date. You will get a negative value if the Start Date exceeds the End Date. The Compare Dates function is beneficial for users who need to perform date comparisons for various purposes, such as calculating due dates, determining the duration between events, or making decisions based on the time difference between two dates.
The difference is calculated as End Date - Start Date. You will get a negative value if the Start Date exceeds the End Date. The Compare Dates function is beneficial for users who need to perform date comparisons for various purposes, such as calculating due dates, determining the duration between events, or making decisions based on the time difference between two dates.
Use Cases
The Date/Time Formatter action is helpful in various scenarios and for users who need to manage and manipulate date and time data. Here are some usage cases:
Event organizers: Format event start and end dates and times received from different sources to maintain consistency and make the data more readable.
Marketing teams: Use formatted date and time information in email campaigns, SMS, or Slack messages for personalized and time-sensitive communication.
Sales teams: Compare the current date with invoice due dates to send automated reminders to clients with upcoming or overdue payments.
Customer support teams: Reformat date and time data received via inbound webhook triggers to create support tickets or update CRM systems.
Project managers: Compare project start dates and deadlines to calculate the time remaining and send notifications to team members.
Data analysts: Store consistently formatted date and time data in spreadsheets or databases, making analyzing and generating reports easier.
Software developers: Integrate formatted date and time data from various sources in their applications, ensuring compatibility and smooth data processing.
E-commerce businesses: Reformat order and delivery date information for better tracking and customer communication.
Frequently Asked Questions
Q. How do I use the formatted date or time in other workflow actions?
Once the Date/Time Formatter action processes a date or time, it stores the reformatted value in a dynamic variable (e.g., {{datetime_formatter.1.date}}, {{datetime_formatter.1.datetime}}). You can reference this variable in subsequent workflow actions, such as sending emails, updating CRM fields, or triggering conditional logic based on the date value.
Q. What happens if I select the wrong format in the “From Format” field?
If the selected From Format does not match the actual format of the input date, the workflow may fail to process the date correctly. This can result in missing or incorrect date values. Always ensure that the From Format accurately represents the original date structure before converting it.
Q. Can I compare a date field from a contact’s record with the current date?
Yes, the Compare Dates function allows you to compare a stored contact date (e.g., “Signup Date” or “Last Purchase Date”) with the Current Date. This can be useful for triggering reminders, follow-ups, or automated actions when a certain number of days have passed. The difference in days will be stored in {{datetime_formatter.1.days}} for further use in workflows.
Q. Can the Date/Time Formatter action handle time zone differences?
The Date/Time Formatter action processes dates and times based on the system’s default time zone settings. If your workflow involves users across different time zones, ensure that you standardize all date/time values or convert them accordingly before applying formatting.
