Error getting while reading a date after splitting

Help Activities
, , , ,
1

Hi everyone, I’m facing a issue with date. I’m explain my scenario and attaching my process also.

  1. first I’m getting dates in excel sheet (12-02-2020 & 17-01-2020) like this I’m getting.
  2. I’m splitting these dates based on and (&) and writing in excel.
    Ex: A2 = 12-02-2020
    A3 = 17-01-2020
  3. after this I’m reading these dates and I’m converting into my specific date time format and write in my browser activity. But here while converting this date I’m getting error. Both dates are coming in different format after splitting them.
    I’m attaching my Xaml file and my error screenshot also. Can anyone help me with the solution.

IMG_20210218_131325
IMG_20210218_1313252312×1040 762 KB

Date_checking.zip (47.7 KB)

2

Hi @ranaprathap928 ,

Check the below solution
Date_checking.zip (17.0 KB)

3

Hi @aanandsanraj thanks, it is working. If you don’t mind can you tell me what changes you did in this Xaml I’m not able to find exactly what are the changes u did.

4

@ranaprathap928 I glad that code is working for you. Just check the add row activity array property.

5

Thanks @aanandsanraj i will check

6

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