RPA Brasil Date Activities

Bronze Certified

Custom Activity

0 reviews

758

Version:1.0.1

Overview Reviews Questions

Versions

Summary

Some actions that we need to do with dates are often very complex to perform and often require complex code. This package contains activities that facilitate manipulation of dates without the need for code.

Overview

This package has 5 activities for handling dates:

· Calc Age Activity
· Date To String Activity
· String To Date Activity
· Get Business Days Activity
· Get Relative Business Date Activity

Calc Age
Calculates age between two dates and return the result in years, months and days.

Properties
Common
ContinueOnError - A Boolean value specifying if the automation should continue even when the activity throws an error. The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
Input
FirstDate- The first date (or date of birth).
CalcDate - The date used to calculate age. The default value is the current date.
Output
Years - The number of completed years at the calculated age.
Months - The number of completed months at the calculated age.
Days - The number of completed Days at the calculated age.

Date To String
Converts the date component of a DateTime instance to a String without using code.

Properties
Input
InputDate - The date to be converted to string.
ConversionMode - Indicates the conversion mode to be used, it can be:
SpecificFormat - Used to indicate that the conversion will use a user-specified format.
SpecificCulture - Used to indicate that the conversion will take place according to the culture specified by the user.
DayFormat - Indicates the day format used to convert the date when ConversionMode is SpecificFormat.
MonthFormat - Indicates the month format used to convert the date when ConversionMode is SpecificFormat.
YearFormat - Indicates the year format used to convert the date when ConversionMode is SpecificFormat.
DateFormat - Indicates the date format used to convert the date when ConversionMode is SpecificFormat.
Separator - A string containing the separator to be used in formatting the date in text when ConversionMode is SpecificFormat.
CultureName - Indicates the culture to be used when ConversionMode is set to SpecificCulture.
DatePattern - The date pattern used when the selected conversion mode is 'Specific Culture', it can be:
Short  - Converts the date to its equivalent short date string representation.
Long - Converts the date to its equivalent long date string representation.
Output
Result - A string containing the converted date.

String To Date
Converts a String containing a date representation to a DateTime instance.

Properties
Common
ContinueOnError  - A Boolean value specifying if the automation should continue even when the activity throws an error. The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
Input
InputString - A string containing the text to be converted to date.
ConversionMode - Indicates the conversion mode to be used, it can be:
SpecificFormat - Used to indicate that the conversion will use a user-specified format.
SpecificCulture - Used to indicate that the conversion will take place according to the culture specified by the user.
DayFormat - Indicates the day format used to convert the date when ConversionMode is SpecificFormat.
MonthFormat - Indicates the month format used to convert the date when ConversionMode is SpecificFormat.
YearFormat - Indicates the format of the year used to convert the date when ConversionMode is SpecificFormat.
Separator - A string containing the separator to be used when ConversionMode is SpecificFormat.
CultureName - Indicates the culture to be used when ConversionMode is set to SpecificCulture.
Output
Result - The converted date or null if there was an error and ContinueOnError was set to true.

Get Business Days
Returns an IEnumerable<DateTime> with the dates and the number of business days in a specified date range.

Properties
Input
StartDate - Calculation start date.
FinalDate - Calculation final date. It must be greater than or equal to StartDate property.
Holidays - An IEnumerable<DateTime> with holiday dates.
SaturdayAsBusinessDay - Considers Saturday as a business day.
SundayAsBusinessDay - Considers Sunday as a business day.
Output
BusinessDays - An IEnumerable of DateTime with business days.
NumberOfDays - An integer with the number of business days.

Get Relative Business Date
Returns the date of the next business day in relation to the start date and the specified number of business days.

Properties
Input
StartDate - Calculation start date.
NumberOfDays - An integer with the number of business days to add. It must be greater than or equal to 0 (zero).
Holidays - An IEnumerable<DateTime> with holiday dates.
SaturdayAsBusinessDay - Considers Saturday as a business day.
SundayAsBusinessDay - Considers Sunday as a business day.
Output
RelativeDate - The relative final date after added NumberOfDays property value.