Date Time Format change and comparison

[ankush.jeengar]

I have date in “dd/MM/yyyy hh:mm:ss” in Excel file. I have to filter the data of old dates from today.

[Lak_Ui (Lakshmi)]

date1=DateTime.ParseExact(date1,“dd/MM/yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

DateDiff(DateInterval.Day,Datetime.ParseExact(date1,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture),DateTime.Now)>=1

Please try this

[Gokul001 (Gokul Balaji)]

HI @ankush.jeengar

How about this expression?

DtBuild.AsEnumerable.Where(Function(x) Not(String.IsNullOrWhiteSpace(x("Excel date").ToString)) AndAlso (CDate(x("Excel date").ToString)<(new DateTime(Now.Year,Now.Month,Now.Day, Now.Hour, Now.Minute, Now.Second)))).ToArray.copytodatatable

Check out the XAML file

OldDateFromCurrentDate.xaml (7.6 KB)

Regards
Gokul

[ankush.jeengar]

getting this error

[Gokul001 (Gokul Balaji)]

Use Read range activity Instead of Build data Table. Or share sample excel file here @ankush.jeengar

[ppr (Peter Preuss)]

@ankush.jeengar

getting this error

find a firstAid for checking date within a datatable populated from an excel read range

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[Rahul_Unnikrishnan]

Hello @ankush.jeengar
Please check the below video. Here the first thing is the conversion of string to datetime, then do the substraction.

How to Convert String to DateTime in UiPath?| Methods of conversion| Practical demo & Tutorial

Thanks

[supermanPunch (Arpan)]

Hi @ankush.jeengar ,

Could you maybe also try with the below Expression :

FilteredDT = DT.AsEnumerable.Where(Function(x) DateTime.ParseExact(x("Your Date Column").ToString,"dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).Date < Now.Date).CopyToDatatable

Here, DT is the Input datatable read from Excel sheet, FilteredDT is the Output Datatable after filtering.

Also for handling the error on direct CopyToDatatable, refer the post below :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

Let us know if you are still facing issues.

[ankush.jeengar]

Thanks SuperMan @supermanPunch