Date to string conversion

[Hitesh1 (Hitesh)]

Hi team,

Can anyone help me to solve error – string to type date conversion is not valid , generated through below statement

Dt.as enumerable.where(Function (x) CDate(x(date)) < DateTime.now.AddDays(-5)).CopyToDataTable

[THIRU_NANI (NaNi)]

Hey!

Try with parse exact method…

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

Regards,
NaNi

[ushu (Usha kiranmai)]

@Hitesh1 Try the below one with assign activity

Variable of type data table DT1 = DT.AsEnumerable.Where(Function(x) DateTime.ParseExact(x("Date").ToString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")<Now.AddDays(-5).ToString("MM/dd/yyyy")).CopyToDataTable

• DT is the data table contains the actual data
• DT.AsEnumerable.Where(Function(x) DateTime.ParseExact(x("Date").ToString, "MM/dd/yyyy", here MM/dd/yyyy is the format that contains in data table. You can change this according to the format that your data table column has

Check attached workflow for ref

Example.zip (3.2 KB)