How to compare dates in excel file?
I need to compare values in column “Data fine validità” with today.
I found I need to compare dates in “mm/dd/yyyy” format.
I found a file in which it doesn’t work.
Get this error: Cannot perform ‘<’ operation on System.String and System.DateTime.
I’m using this code:
Tabella_input.Select("["+Colonna_fine_val+"] < #"+DataOdierna+"#").CopyToDataTable