UiPath-ADPv1 Advanced Data Manipulation Practice Question
A developer is building a UiPath automation that processes a DataTable named dt_Orders. The DataTable contains a column 'OrderDate' of type String with values like "2023-04-15". The developer needs to filter rows where the order date is after January 1, 2023. Which approach correctly converts and filters the data?
⚠ Common exam trap
The trap here is assuming that the Filter Data Table activity or Select method will automatically interpret date strings correctly, when they actually perform string comparisons.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use a 'For Each Row' loop, convert each row's 'OrderDate' to DateTime using DateTime.Parse, and use an If activity to check if the date is after January 1, 2023.
The correct approach is to iterate through each row, convert the string date to a DateTime object using DateTime.Parse, and then compare it to the target date. This ensures chronological accuracy. Filtering a string column directly, whether via Filter Data Table or Select, performs lexicographical comparison, which is unreliable for dates. Automatic conversion does not occur, so explicit parsing is necessary.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the 'Filter Data Table' activity with the condition 'OrderDate' 'Is greater than' and provide a DateTime variable set to January 1, 2023. The activity will automatically convert the string column to DateTime.
Why it's wrong here
The 'Filter Data Table' activity does not automatically convert string columns to DateTime. If the column is of type String, the condition will still perform a string comparison, leading to incorrect results. The developer must explicitly convert the column or use a different method that handles type conversion.
- ✓
Use a 'For Each Row' loop, convert each row's 'OrderDate' to DateTime using DateTime.Parse, and use an If activity to check if the date is after January 1, 2023.
Why this is correct
Converting each string to DateTime with DateTime.Parse ensures proper chronological comparison. The If activity then accurately evaluates whether the order date is after the specified date. This approach is straightforward and works for any date format that DateTime.Parse can handle, making it reliable for this scenario.
- ✗
Use the 'Select' method on the DataTable with a filter expression like "OrderDate > '2023-01-01'". This leverages the DataTable's built-in filtering capabilities.
Why it's wrong here
The 'Select' method uses expression syntax that treats the string 'OrderDate' as a string, leading to lexicographical comparison. For example, '2023-02-01' would be considered greater than '2023-01-01', but '2022-12-31' would also be greater because '2' > '1' in string comparison. This is incorrect for date logic.
- ✗
Use the 'Filter Data Table' activity with a condition on the 'OrderDate' column, selecting 'Is greater than' and entering '2023-01-01' as a string.
Why it's wrong here
The 'Filter Data Table' activity compares values based on the column's data type. Since 'OrderDate' is a String, a string comparison would be lexicographical, not chronological. This could incorrectly include or exclude dates depending on the format. For reliable date filtering, the column should be converted to DateTime first, or the filter should use a DateTime object.
About these practice questions
This UiPath-ADPv1 question is part of Courseiva's 276-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official UiPath exam blueprint
This UiPath-ADPv1 practice question is part of Courseiva's free UiPath certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the UiPath-ADPv1 exam.