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.