Filter date from datatable

[gupta.rak1984 (Rakesh Gupta)]

Hi,
I have stored below details into datatable.

In above datatable date is in DD-MM-YYYY format.
Now i have to compare this date with today’s date. I am writing below code but getting errors.

DtTable.Select(“'”+DateTime.ParseExact(DtTable.Rows(“Due Date”),“mm-DD-yyyy”,System.Globalization.CultureInfo.InvariantCulture)+“‘<=’+DateTime.Now.ToLocalTime+'”)

Please help me to resolve this.

[supermanPunch (Arpan)]

@gupta.rak1984 You have two different type of Date Formats present in the Datatable, That might not be good for Processing the Statement you used which takes only one Format, Only Two types of Format are used, or are there more than two?

[gupta.rak1984 (Rakesh Gupta)]

Only 2

[supermanPunch (Arpan)]

@gupta.rak1984 What should be your result After Comparison ? Do you want to Filter the rows based on Date which are less than or equal to today’s Date ?

[gupta.rak1984 (Rakesh Gupta)]

Yes date should be less or equal to today’s date

[gupta.rak1984 (Rakesh Gupta)]

@gupta.rak1984

DtTable.Select(“’”+DateTime.ParseExact(DtTable.Rows(“Due Date”),“mm-DD-yyyy”,System.Globalization.CultureInfo.InvariantCulture)+“’<=’+DateTime.Now.ToLocalTime+’”)

I am unable to understand whats wrong in this code and why its not working

[supermanPunch (Arpan)]

@gupta.rak1984 Have you Checked with this Code :
DtTable.Select(“[Due Date] <= '”+DateTime.Now+'")

[gupta.rak1984 (Rakesh Gupta)]

Yes tried but no luck , I believe we need to change format of [Due Date]

[supermanPunch (Arpan)]

@gupta.rak1984 Have you tried Filter Datatable Activity?
Considering your Column Value is in Date Format in Excel , It should Work

[alin.c.mihalea]

Hey, @gupta.rak1984

Give this a try:
FilterDate.zip (24.4 KB)
If those are the only two date formats in your datatable, it should work without a hitch.

[gupta.rak1984 (Rakesh Gupta)]

Thanks a lot @alin.c.mihalea