Compare to today date with and column date

[Abubakkar (vnrabu)]

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

[Manohar1 (Adicherla Manohar)]

@Abubakkar

please go through the below topic

Comparing Excel column data of date with system date

I want to compare the date of my excel data with system date. If it matches the matched rows will be copied to another sheet or excel file. But i’m not sure how to do it.

Regards,
A Manohar

[Abubakkar (vnrabu)]

Thanks for the help @Manohar1.

Still i’m getting this error

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

[Manohar1 (Adicherla Manohar)]

@Abubakkar

The resultant variable data type should be of system.datetime

[Abubakkar (vnrabu)]

Pls find my workflow screenshot

[Abubakkar (vnrabu)]

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

[Manohar1 (Adicherla Manohar)]

@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 (vnrabu)]

@Manohar1

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

[Manohar1 (Adicherla Manohar)]

@Abubakkar

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

[Abubakkar (vnrabu)]

this is my excel column name date
only for number digits

[omprasad]

Please Check This

Thanks & Regards
Om Prasad

[Abubakkar (vnrabu)]

[Manohar1 (Adicherla Manohar)]

@Abubakkar

Main.xaml (7.5 KB)

[Abubakkar (vnrabu)]

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?

[sarathi125 (Parthasarathi)]

@Abubakkar,

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

System.DateTime.Now.Date.Day.ToString

[Manohar1 (Adicherla Manohar)]

@Abubakkar

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

[Abubakkar (vnrabu)]

Thanks @Manohar1.

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

[Manohar1 (Adicherla Manohar)]

@Abubakkar

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

[Abubakkar (vnrabu)]

yeah, I clicked on add headers property

[Abubakkar (vnrabu)]

Main.xaml (40.0 KB)