Thank you for trying. It produced an error each time (I created a write line of “error” if it failed). I am attaching the xaml if you want to look. My automation looks at a spreadsheet (larger than the one I sent you) and assigns a variable to the field that I sent you (date). I compared this date to now.toshortdatestring and it failed. It did not matter whether i did it this way or by referencing the row(“date”).tostring method that you sent me and I did change"date" to my column name. I will send the output screen shot next. Thank you again.
i m facing a little diff scenario.
in that there is an excel sheet containing date column with time
eg.–11/13/2019 12:26:49 AM
So scenario is when i run the bot first time lets say 11/13/2019 12:26:49 AM on this date and time.
now if i hv to run the bot again on same date but after 12:26:49 AM like 05:30:33 PM
then Bot should not include the data associated with 12:26:49 AM this time …it should process the data from the last time when i ran the bot…
on daily basis i am exporting this file from web, and i am getting some comments in another column of this excel and i have to print those comments in a word file one by one.
let’s say 2019-11-11 08:59:11 am i got one comment , now if i run the bot again at 04:20:22 pm
suppose i get 5 more entries after 08:59:11 am till 04:20:22 pm .
now my requirement is ,when i run the bot again i want to get only those comments that came after 08:59:11 am.
Hope you got some idea…
if not pls let me know…