Business Solutions
Business Solutions
Professional Services
Professional Services
Collections
Collections
Business Solutions
Business Solutions
Professional Services
Professional Services
Collections
Collections
English
|
Japanese
Sign In
Summary
Summary
Overview
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.
Features
Features
Additional Information
Additional Information
Dependencies
Code Language
C#, Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
Apache
Privacy Terms
Technical
Version
1.0.1Updated
12 Mar 2021Works with
UiPath Studio 2020.10 or higher
Certification
Silver Certified
Tags
Age calculation
Date Conversion
Working day calculation
Support
UiPath Community Support
Resources
Similar Listings
