query to select dates from a text field

[Dale Walker]

I've just received a table that contains dates and normal text strings
in the same field. How can I create a query to select just those with
a date format?

 

[Ken Snell]

SELECT * FROM TableName
WHERE IsDate(Nz([FieldName], "")) <> False;