I’m looking for an idea on how to easily find and eliminate bad dates in a text field.
The field is set to text and good dates are in either mm/dd/yy or mm/dd/yyyy. There’s a lot I can do to prevent them in the first place, but I’m looking for better ideas than I’ve had on my own of how to select those that are entered instead as // or Joe or 12345.
All of my “best” ideas run into an illegal date error.
I need something that equates Select date(TheField) = -1