Filtering specific rows based on specific rules

[hp321 (ap)]

How I can keep rows that the DateColumn is one of the below:
*empty
*N/A
*before the year 1980
*after the year 2100

and basically,any other irrelevant dates.

Thank you.

[ppr (Peter Preuss)]

@hp321
thanks for the PM

Linkin to a solution suggestion

Converting object to MM/dd/yyyy

this description differs from above code lines above code is adding for all an empty row to dt1 However we can take and understand it as filter case. Also we can extend and additional keep all rows where a non empty row(5) value cannot be parsed into a datetime Kindly note: a value like 123456 will match the isMatch values like 17/12/2004 also will match the isMatch Both above are not dates within the format: MM/dd/yyyy HH:mm:ss We keep in mind the following (as currently only defa…