~4 min10 / 14

String & DateTime Activities

String and DateTime activities cover the most common text manipulation and date/time operations needed during automation: searching, splitting, joining, formatting, regex matching/replacement, and date arithmetic across timezones.

DateTime (4)

Add To DateTimeAdd To DateTime

Adds days, hours, minutes, or seconds to a DateTime value and stores the result.

ParameterTypeRequiredDefaultDescription
InputDateTimeYes—The DateTime variable or value to modify
AmountStringYes1Amount to add (can be negative to subtract)
UnitStringNoDaysTime unit: Days, Hours, Minutes, Seconds, Months, Years
ResultDateTimeYes—Variable to store the resulting DateTime

Format DateTimeFormat DateTime

Formats a DateTime value to a string using a custom format pattern (e.g., yyyy-MM-dd, dd/MM/yyyy HH:mm).

ParameterTypeRequiredDefaultDescription
InputDateTimeYes—The DateTime variable or value to format
FormatStringYesyyyy-MM-dd HH:mm:ssFormat pattern (e.g. yyyy-MM-dd, dd/MM/yyyy HH:mm:ss, MMMM d yyyy)
ResultStringYes—Variable to store the formatted string result

Get Current DateTimeGet Current DateTime

Gets the current date and time (local or UTC) and stores it in a DateTime variable.

ParameterTypeRequiredDefaultDescription
KindStringNoNowNow (local time) or UtcNow (UTC time)
ResultDateTimeYes—Variable to store the DateTime result

Parse DateTimeParse DateTime

Parses a date/time string into a DateTime value, optionally using an exact format pattern.

ParameterTypeRequiredDefaultDescription
InputStringYes—The date/time string to parse (e.g. '2026-03-15', 'March 23, 2026 10:30 AM')
FormatStringNo—Optional exact format pattern (e.g. yyyy-MM-dd). Leave empty for auto-detection.
ResultDateTimeYes—Variable to store the parsed DateTime result

String (9)

Regex Is MatchRegex Is Match

Tests whether a string matches a regular expression pattern and returns true/false.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to test against the pattern
PatternStringYes—The regular expression pattern to test, e.g. ^\d{3}-\d{4}$
IgnoreCaseBooleanNofalseIf true, performs case-insensitive matching
ResultBooleanYes—Variable to store the Boolean result (true if pattern matches)

Regex MatchRegex Match

Extracts the first match (or all matches) of a regular expression pattern from a string.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to search within
PatternStringYes—The regular expression pattern, e.g. \d{3}-\d{4}
MatchAllBooleanNofalseIf true, returns all matches as an array; otherwise returns the first match only
IgnoreCaseBooleanNofalseIf true, performs case-insensitive matching
ResultStringYes—Variable to store the match result (string or string[])

Regex ReplaceRegex Replace

Replaces all occurrences in a string that match a regular expression pattern with a replacement string.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to perform regex replacements on
PatternStringYes—The regular expression pattern to match
ReplacementStringNo—The replacement string. Use $1, $2, etc. for captured groups.
IgnoreCaseBooleanNofalseIf true, performs case-insensitive matching
ResultStringYes—Variable to store the resulting string

String ContainsString Contains

Checks whether a string contains a specified substring and stores the Boolean result in a variable.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to search within
SubstringStringYes—The substring to search for
IgnoreCaseBooleanNofalseIf true, performs a case-insensitive comparison
ResultBooleanYes—Variable to store the Boolean result

String FormatString Format

Formats a string by replacing numbered placeholders {0}, {1}, {2}... with the provided argument values.

ParameterTypeRequiredDefaultDescription
FormatStringStringYes—The format string with placeholders, e.g. 'Hello {0}, you have {1} items'
ArgumentsStringNo—Comma-separated values for placeholders. Use quotes for values containing commas.
ResultStringYes—Variable to store the formatted string result

String JoinString Join

Joins an array or collection of strings using the specified separator and stores the resulting string.

ParameterTypeRequiredDefaultDescription
InputStringYes—The array or collection of strings to join
SeparatorStringNo, The separator to place between items (default: ', '). Use \n for newline.
ResultStringYes—Variable to store the joined string

String ReplaceString Replace

Replaces all occurrences of a search string within the input with a replacement string.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to perform replacements on
SearchStringYes—The string to search for
ReplacementStringNo—The replacement string (empty to remove occurrences)
IgnoreCaseBooleanNofalseIf true, performs case-insensitive replacement
ResultStringYes—Variable to store the resulting string

String SplitString Split

Splits a string by the specified delimiter and stores the resulting string array in a variable.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to split
DelimiterStringNo,The delimiter to split by (default: comma). Use \n for newline, \t for tab.
TrimEntriesBooleanNotrueTrim whitespace from each resulting part
RemoveEmptyBooleanNotrueRemove empty entries from the result
ResultStringYes—Variable to store the resulting string array

String TrimString Trim

Trims whitespace or specified characters from the start, end, or both sides of a string.

ParameterTypeRequiredDefaultDescription
InputStringYes—The string to trim
TrimCharsStringNo—Characters to trim. Leave empty to trim whitespace.
TrimModeStringNoBothWhere to trim: Both, Start, or End Allowed: Both, Start, End
ResultStringYes—Variable to store the trimmed string
Was this helpful?