Select by last 30 days

[ArvSeyZar (Arveen Seyedzare)]

Hello all,

My question in regards to a problem I am running into is identifying the steps in need to take to pull information from a web browser by date. I need to only pull data from the last 30 days on this browser in the attachment.

I know there’s a DateTime variable in UiPath that I would potentially use, but I would love some guidance on where I would go from there. Thank you for any feedback.

[AshwinS2 (Ashwin S)]

Hi @ArvSeyZar

First extract all the information by using DataScrapping

Then in assign activity use new dt=extractdatatable.Select"[Last Edited Date]=‘Now.tostring.AddDays(-30). ToString’"). copy todatatable ()

Thanks
Ashwin.S

[ArvSeyZar (Arveen Seyedzare)]

when I data scrape I am only able to scrape everything under the columns to get the values. When i do the assign activity I get an error for the “extractdatatable” assign activity because I don’t think UiPath recognizes that area. Either that or the there might be an error in the code as the quotations is what’s giving me the error

[AshwinS2 (Ashwin S)]

Show the screenshot

[ArvSeyZar (Arveen Seyedzare)]

[AshwinS2 (Ashwin S)]

Hi @ArvSeyZar

Do One thing

Use Assign and create a datevariable=Now.AddDays(-30).ToString(“MM/dd/yyyy”)

Then Use

Dt.Select(“[Last Edited Date]<=+datevar.ToString+”).CopyToDatatable()

Thanks
Ashwin S

[ArvSeyZar (Arveen Seyedzare)]

would the dt.select be another assign?

[ArvSeyZar (Arveen Seyedzare)]

and to also clarify, I am trying to input this data into excel as well

[AshwinS2 (Ashwin S)]

Yes u can do it based on add data row

Thanks
Ashwin.S