Abubakkar
(vnrabu)
November 27, 2019, 9:17am
1
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
Manohar1
(Adicherla Manohar)
November 27, 2019, 9:19am
2
@Abubakkar
please go through the below topic
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
1 Like
Abubakkar
(vnrabu)
November 27, 2019, 9:44am
3
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)
November 27, 2019, 9:46am
4
@Abubakkar
The resultant variable data type should be of system.datetime
1 Like
Abubakkar
(vnrabu)
November 27, 2019, 9:51am
5
Pls find my workflow screenshot
Abubakkar
(vnrabu)
November 27, 2019, 9:57am
6
How to take the column name (DATE) from the excel?
Manohar1
(Adicherla Manohar)
November 27, 2019, 9:57am
7
@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
Manohar1
(Adicherla Manohar)
November 27, 2019, 10:06am
9
@Abubakkar
can you please post the screen shot of date column in Excel
1 Like
Abubakkar
(vnrabu)
November 27, 2019, 10:07am
10
this is my excel column name date
only for number digits
omprasad
(Om Prasad)
November 27, 2019, 10:08am
11
Please Check This
Thanks & Regards
Om Prasad
1 Like
Abubakkar
(vnrabu)
November 27, 2019, 10:31am
14
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)
November 27, 2019, 10:39am
15
@Abubakkar ,
This will give your current date as “27” string.
System.DateTime.Now.Date.Day.ToString
1 Like
Manohar1
(Adicherla Manohar)
November 28, 2019, 4:53am
16
@Abubakkar
in place of row(“date”).toString use row(“currentDate”).toString
1 Like
Abubakkar
(vnrabu)
November 28, 2019, 4:59am
17
Thanks @Manohar1 .
How to read column name ? that date is in number format
Manohar1
(Adicherla Manohar)
November 28, 2019, 5:02am
18
@Abubakkar
While using Read range activity click on add headers property it will include the first line as headers.
1 Like
Abubakkar
(vnrabu)
November 28, 2019, 5:06am
19
yeah, I clicked on add headers property