Copy if column DATE is today or certain date

Help Studio
, ,
1

Dear Experts,

Am looking for a solution where i could copy certain of column of data if “DATE” column is today.

image

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.

2

Hi @Alfred_Gan

Can you share the sample excel file .

You can try with If activity

3

Hi @Alfred_Gan please try like this, you will get the boolean expression. Use this expression in your if activity.

image
image905×346 14.1 KB

Thanks

4

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.

5

Hi @Tapan_Behera1

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

image

6

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)

image
image290×510 17.8 KB

Regards
Gokul

7

Hi @Gokul001

i tried but error occurred as below.

image
image773×458 52.4 KB

image

8

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

9

Yes @Alfred_Gan, what you want to check? Can you explain here…

10

Hi @Alfred_Gan,

Your problem is solved with this text as 44835 and here is the solution :

image
image863×557 21.9 KB

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.

11

Hi @DIBYAPRAKASH_PRADHAN

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

image
image1920×1080 235 KB

is there anything i miss out?

12

Hi @Alfred_Gan,

Can you elaborate, what’s the exact problem now you facing.

13

Hi @DIBYAPRAKASH_PRADHAN

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

14

Hi @DIBYAPRAKASH_PRADHAN

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.

15

Hi @DIBYAPRAKASH_PRADHAN and all,

Appreciate that if you could look into my bot activities.

Thanks.

16

Hi @Alfred_Gan,

Your code was working fine after a few changes, you can check it out.

Main.zip (38.6 KB)

Regards,
Dibyaprakash

17

Hi @DIBYAPRAKASH_PRADHAN,

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.

19

sorry were you posting something?

20

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.

21

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.