I have a date value in cell B3 ('03-02-1995') and a string value in cell B4 ('String value'). I want to check if cell B3 contains a date value

Help Forum
, , , , , , , ,
1

I have a date value in cell B3 (‘03-02-1995’) and a string value in cell B4 (‘String value’). I want to check if cell B3 contains a date value, then break the flow; otherwise, continue and check is it empty or string value.

Note : In if condition i want to check the cell value contains Date value, String value or it is empty.

2

@Mohammad_Rizwan_03,

Use this condition.

If (DateTime.TryParse(strInput, Nothing),"date", If (String.IsNullOrEmpty(strInput), "empty", "string"))

Here you can pass your B3 cell value in the place of strInput. In case you want to break the loop, use Break activity.

Sample Code:
Main.xaml (8.4 KB)

Input:

This image depicts a sequence in UiPath with two assign activities and one log message activity, where the variable is conditionally assigned based on whether the is a valid date, empty, or a string. (Captioned by AI)
This image depicts a sequence in UiPath with two assign activities and one log message activity, where the variable is conditionally assigned based on whether the is a valid date, empty, or a string. (Captioned by AI)916×615 22.1 KB

Output:
image

Input 2:

This image shows a sequence in a workflow automation tool where a date string is assigned to a variable and evaluated, with the result being logged as either "date," "empty," or "string" based on specific conditions. (Captioned by AI)
This image shows a sequence in a workflow automation tool where a date string is assigned to a variable and evaluated, with the result being logged as either "date," "empty," or "string" based on specific conditions. (Captioned by AI)944×632 25.2 KB

Output:
image

Thanks,
Ashok :slight_smile:

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.