Compare to today date with and column date

How to take the column name (DATE) from the excel?

@Abubakkar

Inside For each row

use Assign activity and include the Column Date in it.\

columnDate=DateTime.ParseExact(row(“column name”).ToString(),“MM/dd/yyyy hh:mm:ss”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)

In row(“Column name”) give your date column name

now use if condition and do compare of

current date=columnDate

@Abubakkar

can you please post the screen shot of date column in Excel

1 Like

this is my excel column name date
only for number digits

Please Check This

Thanks & Regards
Om Prasad

1 Like

@Abubakkar

Main.xaml (7.5 KB)

1 Like

Thanks for the help @Manohar1.

How can i find column name date is 27 ?
i need current date till record only in excel sheet
rest of the 28,29,30 column name date is should be removable
row(“Date”).ToString=currentDate is that ok?

@Abubakkar,

This will give your current date as “27” string.

System.DateTime.Now.Date.Day.ToString
1 Like

@Abubakkar

in place of row(“date”).toString use row(“currentDate”).toString

1 Like

Thanks @Manohar1.

How to read column name ? that date is in number format

image

@Abubakkar

While using Read range activity click on add headers property it will include the first line as headers.

1 Like

yeah, I clicked on add headers property

Main.xaml (40.0 KB)

Kindly try with this expression in this assign activity inside the for each row loop
Columndate = row(Now.ToString(“dd”))

Cheers @Abubakkar

1 Like

image

1 Like

Yah
Cheers @Abubakkar

1 Like

Thanks @Palaniyappan

but i can’t compare this column name and current date

i want to compare in this column name todaydate (28) and current date (28)

May I know why
@Abubakkar

1 Like