English
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
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.
Benefits
Published: 13 Apr 2021 | Updated: 13 Apr 2021
License
Apache 2.0
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Age calculation
Date Conversion
Working day calculation
Compatibility
UiPath Studio 2020.10 or higher
Dependencies
UiPath.UIAutomation.Activities 20.10.5 or higher
Support
UiPath Community SupportSimilar Listings
