RPA Brasil Date Activities

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.

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 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 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 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.

This package makes it possible to convert from date to text, and vice versa, using various formats and cultures; calculate age, including month and days beyond the year; calculate several working days; no need for code.