Filter DataTable for Future Dates

[kumar.varun2 (Varun Kumar)]

@amruta_George

The date column must contains all the values in the dd.MM.yyyy format and should not have empty values for the above query to work

If possible please share the sample excel file.

Could you please share the error screenshot also.

Please go through this post also @amruta_George

[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…