Dear Experts,
Am looking for a solution where i could copy certain of column of data if “DATE” column is today.
possible to input over the expression like this?
Or there may be some other activities i could use.
The objective for this is to copy from excel to web column.
Thanks in advance.
Hi @Alfred_Gan please try like this, you will get the boolean expression. Use this expression in your if activity.
Thanks
Excel Sample.xlsx (8.1 KB)
Hi @Gokul001
i tried to come out a sample like this.
i wish to capture the particular job number for today’s date only.
can i have two current row in single expression line?
CurrentRow(“JOB NO”).ToString if CurrentRow(“DATE”).ToString.equals(now.tostring(“ddMMyyyy”))
seems like it doesnt work in this command
Hi @Alfred_Gan
Use IF activity
CDate(CurrentRow("DATE").ToString).ToString("MM/dd/yyyy").Contains(DateTime.Now.ToString("MM/dd/yyyy"))
Check out the XAML file
TodaysDateExcel.xaml (8.2 KB)
Regards
Gokul
HI @Alfred_Gan
In the excel file you having the date as Number 44835
You have to change the cell format
Check out this tutorial and docs
https://www.balareva.com/excel-change-cell-format-in-uipath/
After that you can do you automation
Regards
Gokul
Yes @Alfred_Gan, what you want to check? Can you explain here…
Hi @Alfred_Gan,
Your problem is solved with this text as 44835 and here is the solution :
You can also check out below code :
FormatDateTime.zip (1.7 KB)
You can also change the excel settings for advanced datetime.
Regards,
Dibyaprakash
You can mark it as solution if this one resolves your issue.
i think the expression works but doesnt apply to my bot like i shown below.
it seems like doesnt take the today’s date and input over the website column
is there anything i miss out?
Hi @Alfred_Gan,
Can you elaborate, what’s the exact problem now you facing.
it does not take the date for today and input over the web column.
i tried to change the excel format to any date format i want but somehow still doesnt work.
What i work on is to detect today’s date as there would be many past date and get the job number and copy over the web column.
Thanks to advise
I would share the actual file and the bot
as you could see in my data im trying to capture the date column, if its today, then copy the job no column of number over the web column.
Main.xaml (185.9 KB)
Actual Excel Data.xlsx (508.5 KB)
Hopefully could help for me to elaborate in this case.
Hi @Alfred_Gan,
Your code was working fine after a few changes, you can check it out.
Main.zip (38.6 KB)
Regards,
Dibyaprakash
The JOB NO is suppose to get it from the excel sheet.
Seems like no respond after i run it, it does not take the job no from the excel which is for the date for today.
sorry were you posting something?
Hi All,
Need help as I am still looking for solution for which i want to copy the “JOB NO.” column base on the “DATE” column if its today.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
