Cannot perform '<=' operation on System.String and System.DateTime

[celfa (Claus)]

Hi guys,

I’m trying to filter a DataTable based on a date. However, I keep getting this error message:

Cannot perform ‘<=’ operation on System.String and System.DateTime.

This is what I’m trying to do:
myDataTable.Select("[Completion Date] <= #"+PeriodEnd.ToString +"#").CopyToDataTable

This is an example of a date from my table:
42613 which is 31-08-2016

My PeriodEnd is the following: DateTime.Parse("05/22/2019")

But I just keep getting this error. All suggestions are highly appreciated.

[Pablito (Pawel Wozniak)]

Hi @celfa,
This kind of operation will work with integers as those are number related variables. Have a look here as an examples:

Sorting Date

Hi Everyone, I have a date column in my excel sheet and i want to read only those rows which date is starting from 15 till 31st of a month. Please note that the first value in my date column is not a date it has a number of this form written in it and rest of the date format is dd/mm/yyyy

How to sort a data table based on a column which is a date

How to sort a data table based on a column which is a date

[Palaniyappan]

Buddy both are of different datataype buddy @celfa
they both should be of type datatime if you want to use <=

Cheers @celfa

[Palaniyappan]

Did that work buddy @celfa

[celfa (Claus)]

@Pablito thanks for your input
I’ve checked the links you provided, and they are about sorting? I want to actually filter the table.

However, as @Palaniyappan mentioned my data from the dataTable does not seems to be in the “DateTime” format. It is loaded from a Excel sheet where the column is in the “Date” format. Can I somehow change the format for the column in the dataTable?

[Palaniyappan]

Buddy @celfa

This is what I’m trying to do:
myDataTable.Select("[Completion Date] <= #"+PeriodEnd.ToString +"#").CopyToDataTable

This is an example of a date from my table:
42613 which is 31-08-2016

My PeriodEnd is the following: DateTime.Parse("05/22/2019")

=======================================
Here you are trying to change the value as string buddy PeriodEnd.ToString, while the PeriodEnd is been parsed to datetime…pass it as it is buddy like just PeriodEnd and i
hope the column Completion Date is of type datetime, so that would work buddy

Kindly try this and let know buddy
Cheers

[celfa (Claus)]

@Palaniyappan I’m not allowed just to write just PeriodEnd without change it to a string?
My “Completion Date” column is in date format.

[aksh1yadav (AKSHAY YADAV)]

myDataTable.Select("[Completion Date] <= #"+PeriodEnd.ToString +"#").CopyToDataTable

hey @celfa

Try this -

myDataTable.Select("[Completion Date] <= '"+PeriodEnd.ToString("MM/dd/yyyy")+"'").CopyToDataTable

Regards…!!
Aksh

[celfa (Claus)]

Hey @aksh1yadav

I’ve tried that, but the result is not as expected. The filter does not seem to work. I tried to check the actual column data type with DT.Columns(22).DataType.ToString, and it is in System.Object. So I think that my issue is related to the column type?

[celfa (Claus)]

So I realised the issue was related to the read range from excel sheet activity. I created a new sheet with the exact values instead of formulars and then it worked like a charm.

Thanks for the input @Palaniyappan @Pablito @aksh1yadav