Compare to today date with and column date

Dear experts,

I will compare today date is 27 with and excel column name today date is 27?

Could anyone help me please?

Thanks in Advance

1 Like

@Abubakkar

please go through the below topic

Regards,
A Manohar

1 Like

Thanks for the help @Manohar1.

Still i’m getting this error

my current date is this date formula Convert.ToInt32(now.ToString(“dd”))

@Abubakkar

The resultant variable data type should be of system.datetime

1 Like

Pls find my workflow screenshot

image

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)