Workflow Action - Dare/Time Formatter

Overview

The Date/Time Formatter action allows you to format and compare date fields within workflows. This action helps transform or evaluate dates to better suit specific conditions or outputs. Action NameDate/Time FormatterAction Description1. Format DateDescription: This action converts a date field from one format to another within a workflow.

For example, you can convert a date from "MM/DD/YYYY" to "YYYY-MM-DD" to standardize dates for consistent reporting or communication.

Use Case

: Useful when you need to ensure a uniform date format across various systems or reports. 2. Format Date and TimeDescription: This action converts both date and time fields from one format to another. This action is especially useful for timestamps that include both date and time components.

Use Case

: Great for workflows that deal with appointments or timestamps, where both date and time need to be reformatted. 3. Compare DatesDescription: This action compares two dates and evaluates which date is earlier, later, or whether the dates are equal. This can be used to trigger actions based on whether one date is within a specific time range of another date.

Use Case

: Ideal for workflows where you want to compare registration dates with event dates or any other form of time-sensitive comparison. Action DetailsFormat DateAction DetailsField NameDescriptionMandatoryAction NameThe unique name you want to assign to this action. YesAction TypeChoose the type of formatting action (Format Date, Compare Dates). YesFieldSelect the date field you want to format or compare.

YesFrom FormatDefine the existing format of the date field. YesTo FormatDefine the desired format for the date field. YesExample Workflow: Trigger: Form SubmissionAction: Format the date of submission to YYYY-MM-DD format for further usage in reporting.----------------------------------------------------------------------------------------------------------------------Format Date and TimeAction DetailsFieldDescriptionMandatoryAction NameThe name you assign to this specific action.

YesAction TypeSelected as “Format Date and Time.”YesFieldThe field containing the date and time to be formatted. YesFrom FormatThe current format of the date and time (e.g., DD/MM/YYYY HH:mm). YesTo FormatThe desired format for both date and time (e.g., MM-DD-YYYY HH). YesExample Workflow: Trigger: Appointment CreatedAction: Format the appointment date and time from Unix timestamp to readable format for notifications.----------------------------------------------------------------------------------------------------------------------Compare DatesAction DetailsFieldDescriptionMandatoryAction NameThe name you assign to this specific action.

YesAction TypeSelected as “Compare Dates.”YesStart DateThe first date field you want to compare. YesStart Date FormatThe format of the first date (e.g., MM-DD-YYYY). YesEnd DateThe second date field to compare. YesEnd Date FormatThe format of the second date (e.g., DD/MM/YYYY).

YesExample Workflow: Trigger: Event RegistrationAction: Compare registration date with the event date to send reminders if the event is within 3 days. Date and Time Format SupportedFormat TypeExample OutputYYYY-MM-DD45281MM-DD-YYYY45281MM/DD/YYYY45281MM/DD/YY45281DD-MM-YYYY21-12-2023DD/MM/YYYY21/12/2023DD/MM/YY21/12/23DD MMM YYYY45281D MMMM YYYY45281MMMM D, YYYY45281MMM DD, YYYY45281MMMM Do YYYYDecember 21st, 2023X (Unix Timestamp)1703176259