How to store date value in Datatable in Ui path?

I am having assign variable with date value: experienceDate = 01/12/2023 - 22/08/2023.
I want to store experienceDate in a datatable. What type should i choose to store the experienceDate?

Please give me solution with an example. Thanks.

1 Like

@Gowthaman_Gajakutti

Choose string Datatype

Thank you

Hi @Gowthaman_Gajakutti

Use Update row Item activity to update the specific row in the datatable.
Store the experienceDate in a Variable. The datatype of experienceDate variable is in System.DateTime

=> Assign -> experienceDate = "01/12/2023 - 22/08/2023"

Check the below image.
image

In the Value field pass the experienceDate Variable
In the Row field give the row range in where you want to update.
In the column you can specify the column.

Hope it helps!!

You can set the column datatype as datetime if your storing dates from 01/12/23 to 22/08/2023

Hi @Gowthaman_Gajakutti

Try this

1 Like

It really works. Thanks a lot for your support.

1 Like

Thanks @rlgandu It works fine.

@Gowthaman_Gajakutti
If you got the solution for your question. Please mark it as solution to close the loop.

Hi @lrtetala
I want to capture date from this page. I used get Text activity to capture data from the page and write cell activity into an excel.

I could not capture two company experience details with get text activity. Bot is getting stopped when one experience detail presented in the page.

Please help me. Thanks.

@Gowthaman_Gajakutti

Then accordingly you have to make it dynamic to extract how many ever are presnet…use find children or for eqch ui element activities to do this task

Cheers