show / hide menu

Sub Activity – DateTime

DateTime includes activities for manipulating and formatting date and time values, allowing you to perform operations such as calculating time differences, adding/subtracting dates, and formatting date/time outputs.

The DateTime activity has the following sub activities:

Add DateTime: This activity allows the user to add a Date and Time by giving an interval specified by the user in the properties section.

Input Properties:

  • Interval– The time/date interval to add.
  • DateTime– Date time to which number is to be added.
  • Number– The number of intervals to add to the date. Positive values give future dates, while negative values give past dates.

Output Properties:

  • Added DateTime– The variable that stores the added DateTime value.

Current DateTime: This activity gets the Current Date Time of a Specified TimeZone.

Input Properties:

  • TimeZone– Select the standard time zone.

Output Properties:

Current DateTime– The variable that stores the standard time for the selected time zone.

DateTime Difference: This activity can be used to find the difference between the specified Start and End datetime.

Input Properties:

  • Interval– Select the interval to calculate the DateTime difference. Or Select the part to return for the DateTime difference (e.g., year, month, day).
  • StartDate – Specify the starting DateTime for the difference calculation.
  • EndDate– Specify the ending DateTime for the difference calculation.

Output Properties:

  • Date Difference– The variable that stores the calculated difference between two DateTime values.

DateTime Part: This activity is used to get a part of the date.

Input Properties:

  • Interval– Select the specific part of the DateTime argument to return (e.g., year, month, day).
  • DateTime– The DateTime from which the specified part is to be extracted.

Output Properties:

  • DatePart– The variable that stores the integer value of the DateTime part.

Format DateTime: This activity converts a specific date-time into any format of the user’s choice in the form of an output string variable.

Input Properties:

  • Value– Enter the DateTime value to be formatted.
  • Format– Select the desired DateTime format.

Output Properties:

  • Formatted DateTime– The variable that stores the formatted DateTime.