Extract Date from DateTime stamp (Data Scraping)

Help Activities
, , ,
1

I am scraping data from a website with datetime stamp as a column. I want to extract only the date portion and output to csv file.
I have tried using the filter data table function but cant seem to separate the outputs

2

Hello,
Could you please share some more details, if possible some screenshot?
BR,
CK

3

data
data1727×892 245 KB
workflow
workflow592×560 28.8 KB

From the shipping history data table i am extracting the ship date column and inputting into a CSV file. However, the “ship date” shows as a datetime stamp and I only want the date portion and not the time

4

Hi @Jeff_Varghese

welcome back to forum

If u need only date part in the csv file u can use the below code in invoke code activity with dt1 datatable argument as In/Out

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(ColumnName)= CDate(row(ColumnDate).ToString).ToString(“dd/MM/yyyy”))

This would be good approach

Regards,
Nived N
Happy Automation

5

I am very new to UiPath. Would you mind showing me an example of this ?

6

Hi @Jeff_Varghese
check this
Main.xaml (7.2 KB)

Change the column name according i had put it as “Date” for demonstartion

image

Hope the idea helps you

Regards,
Nived N
Happy Automation