Compare dates of excel sheet in uipath

Hello Everyone,
In this sheet. We have to get INVOICE DATE > G/L DATE of INDEX NO And also we need to know the difference between G/L DATE and the DUE DATE of INDEX NO.

Index No Invoice Date G/L Date Due Date
121 10/09/2020 09/09/2020 10/09/2020
122 02/09/2020 07/09/2020 02/09/2020
123 28/08/2020 07/09/2020 27/09/2020
124 25/08/2020 07/09/2020 24/09/2020
125 03/09/2020 07/09/2020 17/09/2020
126 26/08/2020 07/09/2020 09/09/2020
127 03/09/2020 07/09/2020 10/09/2020
128 19/08/2020 07/09/2020 14/09/2020

Please support us to solve this issue. With example workflow

1 Like
  1. read excel data to datatable
  2. foreach row
  3. parse string to datatime : DateTiem.Parse Method or TryParse Method
  4. compare and - operation
    good luck

Thank you so much. We are new to UIPATH. Can you help with workflow.?

1 Like

Hey @Udesheyy, Welcome to the Community

Please go through the below steps,

  1. Read the excel range & store in a data table using Excel scope and read range activity

  2. Use foreach and iterate through the data table holding the excel data

  3. Inside foreach perform condition check using IF

Iā€™m attaching the workflow for the same, Below is what it does.

  1. It will find the index number for which invoice date > GL date

  2. For the filtered index number - It will find the GL and due date difference in days

  3. Write output in Excel (output sheet)

PFA - ExcelDates.zip (10.4 KB)

Also, Have a look at the DateSheet.xlsx which has both input and output data in separate sheets. Kindly confirm this is what you were expecting.

Hope this helps.

Thanks :slight_smile:

1 Like

Thank you soo much. I will check and let you know. :slightly_smiling_face:

1 Like

Hello @Nithinkrishna,
This is very helpful for me to complete my project. I really thankful to you for supporting me.

Thank you @Nithinkrishna :slightly_smiling_face:

1 Like