Connect HomeMarketplaceComponentsNovigo Solutions - DataTable Date Formatter

Novigo Solutions - DataTable Date Formatter

Custom Activity

Custom Activity

Updated: September 18th, 2020

Published: May 24th, 2020

Downloads: 15

Industry: cross-industry

Language compatibility: Visual Basic

Community Support

Novigo Solutions - DataTable Date Formatter

Custom Activity


The activity finds a solution to the problem of DataTables with multiple date formats in the same column (of type string), by converting them to the same format

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


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.



In scenarios where we receive a DataTable with a column that does not follow an uniform format for dates we can make use of this activity to standardize the dates to a common format.


Compatible with all versions of UiPath starting from 20.4




- Activity Description.pdf
- IO_Screenshots.pdf


By clicking download you agree to the following license.