How to compare the current date with the excel file column

Help Activities
,
1

Hi all,
How to compare the current date with the column of excel.

image
image1366×768 93.1 KB

Used this condition not able to write the compared data to excel.
Current date => now.AddDays(5).ToString("dd-MM-yyyy")

Column date
image

Condition to compare:

CDate(End_dateRow).ToString(“dd-MM-yyyy”) >= Current_date

Please guide me on this.

2

Hi @lakshmi.mp

End_dataRow=Datetime.ParseExact(CurrentRow("Column date").ToString, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture)

In If Condition
      End_dataRow>=Current_date
3

@lrtetala ,

image
image1366×768 98.5 KB

Can you check this screenshot.

4

@lakshmi.mp

After For each row in data tale you can please this activity

5

Hi @lakshmi.mp

Try this:
For comparing:
DateTime.ParseExact(row("End_dateRow").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture) >= DateTime.Now.AddDays(5)

6

Hi @lakshmi.mp ,

Hope you are doing good.

If you don’t mind, can you please elaborate what needs to be done, is today date needs to compare with date in the Excel and find the difference?

Thanks,
Sandhiya P

7

@lrtetala ,

image
image1366×768 97.4 KB

After for each row Assign activity, then if condition placed.
Cannot assign date time to string error getting…

8

Change Data type to System.DateTime @lakshmi.mp

9

Place this in if condition @lakshmi.mp

DateTime.ParseExact(row("End_dateRow").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture) >= DateTime.Now.AddDays(5)

10

@lakshmi.mp

In For Each Row in datatable
    Assign: End_dataRow= Datetime.ParseExact(CurrentRow("Column date").ToString, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture)    DataType:System.DateTime

    Assign: CurrentDate= DateTime.Now.AddDays(5)     DataType:System.DateTime

In If Condition:

     End_dataRow>=CurrentDate

Sequence
Sequence882×1062 65.7 KB

Hope this helps!!

11

@lakshmi.mp

Check on this xaml

BlankProcess12.zip (67.6 KB)

12

@lrtetala ,
Assign: Conversion from string “14-10-2023” to type ‘Date’ is not valid.
Error for current date
Data type is DateTime for Current date

13

@lakshmi.mp

Are you tried this

14

@lakshmi.mp

Try this

CurrentDate=DateTime.Now.AddDays(5) DataType:System.DateTime

It is working

15

@lrtetala ,

It’s not filtering full excel sheet data writing into next sheet…

16

@lakshmi.mp

Can you please confirm what you are trying?

If this condition is true
End_dataRow>=CurrentDate
what is the next step

17

@lrtetala ,
if:

End_dateRow>= Current_date
then that data has to be written into excel.

18

Test123 - Copy.xlsx (23.0 KB)
This is the excel file. Please look into it.
Here New column 3 has dates current date + 5 days is the current date.
if New column 3 dates >= current date, needs to be filtered.

19

Hi @lakshmi.mp ,

If you want to write it like a data table then you have to use Data row and add to data table activity.

  1. Build Data Table
  2. Create an Array
  3. Add data row to data table
  4. Write data table to excel.

Otherwise you can use write cell activity inside for each loop.

Thanks,
Sandhiya P

20

@sandhiya.ppp ,

image
here data is not filtering, can u guide me on this.
Test123 - Copy.xlsx (23.0 KB)
End date filter.xaml (13.4 KB)