MarketplaceListingsCustom ActivityNovigo Solutions - DataTable Date Formatter

Novigo Solutions - DataTable Date Formatter

by Novigo Solutions

2

565

Novigo Solutions - DataTable Date Formatter

by Novigo Solutions

2

Custom Activity

565

Summary

Summary


Overview

Overview

This activity is capable of converting a data column with inconsistent date formats into a consistent or uniform format.

Inputs:

1. DataTable: The data table variable which consists of a column having inconsistent date formatting (Doesn’t follow a uniform date formatting).
2. ColumnName (of String): The name or index of the column to be standardized as a string.
3. DateFormats: All the available string formats followed by the column have to be listed as an array of string.
4. RequiredFormat: The uniform date format to which the column is to be converted.

Outputs :

1. OutputTable: The output data table with the formatted output (The output datatable should preserve the schema of the input datatable).

2. FormattingFailedIndexes: The row indexes for which the formatting has failed since a matching input date format was not found for those dates.

Please check the video URL attached with this upload if you have any doubts.

Features

Features


Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Novigo Solutions

Visit Publisher's Page

Trusted Source

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.0

Updated

30 Jun 2020

Works with

Compatible with all versions of UiPath starting from 20.4

Certification

Silver Certified

Tags

column
data
datatable
date
date formatter
formatter
same format for dates
uniform date

Support

UiPath Community Support

Resources

Similar Listings