I have an excel file where my data is of date type, what I want is to enter a date via input dialog with uipath and filter it with the whole row from the date I entered to the last date in excel and print it to another excel file. But since the date data is in date type in excel, uipath automatically changes the date format to MM/dd/yyyy and in every activity or gives an error.
For example if I enter 19.06.2021 in my input dialog. It will filter from the date I entered until 31.07.2021 and will be printed in another excel table along with the data in the other columns.
Assign activity
left side: drResult | DataType: List(Of DataRow)
Right side:
(From d In dtData.AsEnumerable
Where Not (IsNothing(d(ColNameOrIndex)) OrElse String.IsNullOrEmpty(d(ColNameOrIndex).toString.Trim))
Let dp = dateTime.ParseExact(d(ColNameOrIndex).toString,"MM/dd/yyyy HH:mm:ss", CultureInfo.InvariantCulture).Date
Where dp >= FilterDateVar And dp <= EndDateVar.Date
Select d).toList
Yes, what you did is correct, but I need to print from that date until 31.07.2021, which is the last date in excel. İn your ğproject, it just prints 19.06.2021 which is the date in the variable. How can I do this pls help me mate thanks for ur answers.