Definition and Usage
This command converts a datetime value to a formatted text string. It allows you to transform datetime objects into readable text formats that can be used in reports, displays, or other text-based outputs.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Datetime to convert | Enter the datetime value to convert to text | Any valid datetime value | Yes | Can use variables as input |
Use custom format | Use a custom format to interpret the original date/time | True/False | No | When checked, enables custom formatting |
Input format | Enter the format that matches your original date/time | Format string (e.g., yyyy-M-d) | Yes, if custom format is enabled | Example: yyyy-M-d for 2025-1-1 |
Output format | Select an output format to display datetime value | Predefined format options | Yes | Determines how the datetime will be formatted |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action produces a text variable containing the formatted datetime string, as specified in "Store formatted datetime into" parameter.
Using Variables in Conditions
You can use variables in the "Datetime to convert" field by clicking the {x} button to insert previously defined variables. This is useful when you need to format datetime values that are dynamically generated from other actions.
Notes
The "Input format" parameter is only available when "Use custom format" is checked
Common datetime format patterns include:
yyyy: 4-digit year (e.g., 2023)
MM: 2-digit month (01-12)
dd: 2-digit day (01-31)
HH: 24-hour format (00-23)
mm: minutes (00-59)
ss: seconds (00-59)
Ensure the datetime value provided is in a valid format that can be recognized by the system
If no custom format is specified, the system will attempt to automatically detect the datetime format