Change Date Format

This is a pre-built Action located under the @Generic Element. The functionality of this Action in Avo Assure is to change the format of the given date based on the format specified in the input value column. The execution status is then stored in a dynamic variable.

Syntax

Input Value: <date>;<current format>;<required format>

Argument	Description
<date> (Required)	Provide the date that needs to be converted.
<current format> (Required)	Provide the current format of the given date.
<required format> (Required)	Provide the format in which you want the date to be converted. Supported date formats are: dd/MMM/yyyy  MMM/dd/yyyy  dd/MM/yyyy  MM/dd/yyyy

Output Value: <Dynamic Variable>;<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the converted date format.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example: Converting a Date into a Different Format

In this example, we explain how to convert a date from one format to another.

• Action: Change Date Format

• Input Value: 12/11/2025;dd/MM/yyyy;MM/dd/yyyy

  • The first argument (12/11/2025) specifies the original date.

  • The second argument (dd/MM/yyyy) specifies the current format of the input date.

  • The third argument (MM/dd/yyyy) specifies the required output format.

• Output Value: {Formatted Date}

  • The converted date (11/12/2025) is stored in this {Formatted Date} dynamic variable.

  • If a second output variable is provided, then action returns the status as True or False:

    • True: If the date format is converted successfully.

    • False: If the conversion fails due to an invalid date or incorrect format.

• Logical Explanation: The Change Date Format action fetches the value from the Input Value column (12/11/2025;dd/MM/yyyy;MM/dd/yyyy), converts the date from the current format (dd/MM/yyyy) to the required format (MM/dd/yyyy), and stores the resulting date (11/12/2025) in the {Formatted Date} variable.

Knowledge Bites:

Here are some examples of different date formats:

Date formats	Input Value	Result
dd/MM/yyyy	08/11/2025;dd/MM/yyyy;dd/MMM/yyyy	08/Nov/2025
MM/dd/yyyy	11/08/2025;MM/dd/yyyy;MMM/dd/yyyy	Nov/08/2025
dd/MMM/yyyy	11/Nov/2025;dd/MMM/yyyy;dd/MM/yyy	11/11/2025
MMM/dd/yyyy	Nov/11/2025;MMM/dd/yyyy;MM/dd/yyyy	11/11/2025