The Date/Time Formatter Workflow Action makes it straightforward to handle date and time data in your workflows. You can reformat date structures, compare dates, and automate date-related calculations, keeping things consistent and saving time. This guide covers its capabilities, benefits, and practical applications across various industries.
Start by selecting a trigger, then click the "+" icon to add the Date/Time Formatter action.
Date/Time Formatter Action Type
Format Date
The Date/Time Formatter makes it simple to change date formats. Select a date and it will auto-detect the current format. From there, pick a new format from the list and the changes will be applied.
Format Date and Time
For workflows that include both date and time, the formatter handles full reformatting. Select the field you want to modify, let the feature detect the current format, then choose the format you need.
Compare Dates
This option makes date comparisons straightforward, such as calculating the number of days between two dates. Select a start and end date and the formatter will work out the difference, making it easier to inform data-driven decisions.
📌 NOTE: When comparing dates, the follow-up dropdowns will include the Start date, Start date format, End Date, and End date format.
Field Selection
In the field selection dropdown, choose the date and time field you want to format.
📌NOTE: This option is available for the Format date and Format date and time action types.
Select From and To Format
Choose the format you'd like the date to appear in.
Save the action once you're happy with your selections.
The Date/Time Formatter Workflow Action is a useful tool for anyone working with date and time data. Its automation capabilities and flexibility make it straightforward to optimise workflows across teams and industries, whether you're organising events, analysing data, or improving customer communications.